Questions tagged [qlikview]

QlikView is a business intelligence platform created and distributed by Qlik Corporation. The main aim of the platform is to allow users to self-discover the data that they require using fast in-memory analysis via either a Microsoft Windows Application (QlikView Desktop) or via a web portal (QlikView Portal).

QlikView initially began life as "QuikView" ("Quality, Understanding, Interaction, Knowledge") when it was launched in Sweden in 1993 by Qlik's founders, Björn Berg and Staffan Gestrelius.

Later in 1996 it was renamed to its present-day "QlikView" as its customer presence increased. Since then, the QlikView platform has developed and matured into multiple components:

  • QlikView Desktop: A Windows-based application for in-memory data analysis

  • QlikView Server: A Windows-based server service that provides a way to view QlikView documents via a webserver, and also manage other QlikView components

  • QlikView Product Suite QlikView is a comprehensive business intelligence platform providing powerful business analytics to a broad range of users throughout the organisation. The QlikView suite is designed for application development and data extractions, efficient information distribution and powerful analysis for either the power user or end-user. QlikView can be deployed both offline and online leveraging a range of industry leading technologies.

  • QlikView Local Client This stand-alone Windows client provides the full developer’s ETL and end-user application to develop, deploy and analyse QlikView applications.

  • QlikView Small Business Edition Server This Server version of QlikView provides ones one central computer to handle all reloads, RAM performance and administration. Users can access the QlikView documents via a number of different Clients options – Windows full client, IE Plug in, Ajax (zero footprint) and mobile clients (eg. iPhone, BlackBerry etc). Two different user licenses available – Named Client Access License (CAL) provides one user access to as many QlikView documents as required or Document CAL which enables one user to access one document. Minimum deployment of 5 Named users, maximum of 25. Document CALs are a minimum of 10, with a maximum of 100.

  • QlikView Enterprise Edition Server This is the full enterprise Server version of QlikView, again providing centrality for QlikView reloads, RAM performance and administration. In addition this Server version allows nesting of multiple servers for data load balancing as well as enabling the collaboration feature for the users. Collaboration enables users to create and share their own objects and charts as well as bookmarks with other users.

    Named CALs, Document CALs, Session CALs (Concurrent) and Usage CALs are user license options available. Minimum deployment of 10 Named CAL and Document CALs are a minimum of 100.

  • QlikView Publisher: A Windows-based server service that provides a way to automate the publication of QlikView documents to a web portal, fileshares and end users.

    QlikView Publisher ensures that the right information reaches the right user at the right time. Developed for larger user environments, QlikView Publisher gives further centralised administration and management. QlikView Publisher allows for complete control of the distribution of a company’s QlikView applications through QlikView AccessPoint also automating the data refresh process.

Demonstrations

QlikView Demo Applications

Beginner Resources

Build Your First Application in QlikView (PDF)

References

QlikView Reference Manual (PDF)

1068 questions
3
votes
2 answers

Extension Doesn't Update

This may be a pretty dumb question. I have Qliksense 2.0.1 desktop installed. I am creating an extension object. However, any updates I make in the .js file are never visible. I can make a change in the .qext file and those are visible. This stands…
SwolleyBible
  • 243
  • 7
  • 20
3
votes
1 answer

export to excel two sheets with different names

I have a container that contains two tables : CH10001 and CH10002 with the following code I can export CH10001 sub xport2xl() iRow = 1 set xlApp = CreateObject("Excel.Application") xlApp.Visible = True set xlWB = xlApp.Workbooks.Add …
user3548593
  • 499
  • 1
  • 7
  • 22
3
votes
1 answer

Handle two fact TABLE

I have two facts I use the following code to load from QVD Vente: LOAD PrixUnitaireArticle, PrixArticleHT, PrixRevientTTC, MargeHT, MargeTTC, ValeurRevientHT, ValeurRevientTTC, ValeurMargeHT, ValeurMargeTTC, …
user3548593
  • 499
  • 1
  • 7
  • 22
3
votes
1 answer

How to use macros in qlik view

I just started with qlik view macros just wanted to ask is there any library file or API need to install/add to use macros.
vijay
  • 55
  • 7
3
votes
1 answer

append new information in csv files to existing historical qvd

Let's say I have a "master" qvd file named salesHistory.qvd, and I want to append new monthly sales from file salesMarch.csv How do I do that without replacing existing information, but adding new months? Thanks for the help!
user2784813
  • 57
  • 1
  • 8
3
votes
1 answer

QlikView iis install without QlikView workbench

My organization does not have QlikView WorkBench license. My question is, what are the limitations I will run into as I start using IIS with QlikView instead of QlikView web server. Is it necessary to have workbench installed with license to be…
VivekDev
  • 20,868
  • 27
  • 132
  • 202
3
votes
1 answer

How to create a chart that shows timeline against months in Qlikview?

I need a quick help my requirements are a bit complex. I need to show multiple timelines against months accordingly. Such that on the left side i have all the Products and in the chart i want to show Dates on a time line and bottom line represents…
Ali Shahbaz
  • 825
  • 1
  • 7
  • 19
3
votes
2 answers

Storing multiple tables into a QVD in QlikView

Is it possible to store more than one table's data into a single QVD document? If so, how can I both store and load multiple tables into/from this QVD?
Dexter
  • 12,172
  • 9
  • 27
  • 30
3
votes
1 answer

Creating variable during load script in Qlikview

I am trying to set a variable in my load script using a previous loaded table, for example: Data: load * inline [ Year, Store, Revenue 2008, Amsterdam, 100 2009, Amsterdam, 100 2010, Amsterdam, 100 2008, Rotterdam, 200 2009, Rotterdam, 200 2010,…
dorianpc
  • 319
  • 2
  • 5
  • 10
3
votes
1 answer

QLikVIew reference to a Calculated Dimension in another Calculated Dimension

Is it possible to refer to a Calculated Dimension in another Calculated Dimension in a Pivot Table ? Can ValueList() be used for this usage, and what would be the appropriate syntax for it ? I cannot use the script for this, and I cannot create a…
kiriloff
  • 25,609
  • 37
  • 148
  • 229
3
votes
1 answer

SendKeys does not work for a particular key combination in QlikView 11

As you can see in my script below, I am trying to use SendKeys to send Ctrl+Shift+S to show all sheets and objects in QlikView, but it does not work. However, if I send some other keys like "^s" (Ctrl+S) then it works fine. Set objShell =…
3
votes
0 answers

Qlikview OCX 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))

I work on a web application - ASP.NET MVC 4 (C#) the application works with Qlikview OCX, it needs to open the QW client on the server in order to show up some parameters on the UI; the user must log-in using windows authentication, the app…
Vlad
  • 536
  • 1
  • 5
  • 18
3
votes
1 answer

Business Intelligence Star Model

I have a general question about star model in business intelligence project. For example, let's suppose that the project is comprised of one fact table (F) and 3 dimensions (D1, D2, D3). Furthermore, let's assume that fact table looks like this: d11…
Adam
  • 2,347
  • 12
  • 55
  • 81
3
votes
1 answer

Qlikview in iframe - log in from different domain without asking for credentials

I have to show qlikview document in ASP MVC application, and I have used iframe to do this. But, every time user opens this page it is being asked for credentials for qlikview server (windows security dialog), because qlikview server is not in the…
3
votes
3 answers

QlikView - Use a variable into set analysis expression

I've the variable varCurrentYear varCurrentYear = Year(Today()) And I wrote this set analysis expression The result it’s not correct. By the way If the variable is declared in this way varCurrentYear = 2014 The result is correct. Why? Thank's
JAEP
  • 363
  • 2
  • 5
  • 12
1 2
3
71 72