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
3 answers

Detect Document Reload has occured on server

I have an winform/OCX that consumes a qlikview document. We have gotten a patch from QV so that RefreshDocument works in the OCX as the RefreshDocument does in QV application. But the Application shows a nice enabled button when the document has…
Archlight
  • 2,019
  • 2
  • 21
  • 34
3
votes
3 answers

QlikView:Using dimensions value in expression

I am trying to figure out how can I use dimension values as one of the set modifiers in Expressions in qlikview. Consider the following: Raw Data: PName, count AB,2 BC,3 CD,4 Dimension: Name Expression: SUM(<{PName=Name}>count) i-e using the…
Salik
  • 508
  • 6
  • 17
  • 35
3
votes
2 answers

How to aggregate sum of past 2 values + current value + next 2 values with set analysis?

I want to calculate the aggregate sum of past 2 values + current value + next 2 values with set analysis. With or Without set analysis it works as expect. It works as expected with or without set analysis ("{}"). But when zooming the values…
Gnik
  • 7,120
  • 20
  • 79
  • 129
3
votes
1 answer

Qlikview Expression to get Average in comparison to selected criteria for Chart

I am trying to create a chart that displays the average of a parameter of an entire category. The problem is that in sheet 1,2,3,4, etc, the charts I have reflect one parameter, so when I go to compare this parameter to the average in my new sheet,…
user2662565
  • 509
  • 2
  • 9
  • 22
3
votes
3 answers

Qlikview, how to create an expression which does not change with listbox selection?

Example, I have table below.. Week, Quantity 1, 10 1, 15 1, 10 2, 20 2, 30 3, 10 3, 50 I also have a list box for 'Week' which is current selected on week 2. Now, I want to create text object which shows the value of sum of quantity of week 1 (ie.…
tastefullvenom
  • 31
  • 1
  • 1
  • 2
3
votes
1 answer

how to load NT users from SQL Server DB to grant access to Qlikview files?

is it possible to load 'user' and 'access' data directly from a SQL Server database to compare with the actual NT User logged and grant access to my QlikView file? Thank you in advance.
olaff.lozoya
  • 31
  • 1
  • 4
3
votes
2 answers

How to move files in directory, using QlikView

Can we move files from one folders, using QlikView script?
David Kakauridze
  • 305
  • 4
  • 11
  • 23
2
votes
1 answer

Qlikview V10.4 Threshold and Drill down issue

I am using Qlikveiw version 10.4. I am trying to apply a threshold to Sales amounts in a table chart. Meaning, I want to display Sales above the threshold amount entered in the input box. But also keep the dimensionality of the drill down for the…
2
votes
1 answer

Issue with loading data into Qlik Sense and avoiding circular references and synthetic keys

I am facing a problem with loading data into Qlik Sense and avoiding circular references and synthetic keys. I have tried the script provided below, but it is not working as expected. I would greatly appreciate it if someone could help me with this…
Cepp0
  • 23
  • 4
2
votes
1 answer

Sum of rows below in qlikview

I have a table like this : Date Amount 06/Jan/2021 300 05/Jan/2021 200 04/Jan/2021 -100 03/Jan/2021 -500 02/Jan/2021 200 01/Jan/2021 100 I want to get a column with the running totals but keeping the min amount to 0. The total…
JonJon
  • 41
  • 4
2
votes
1 answer

QVD file to pandas DataFrame

I tried to load a QVD file to pandas dataframe using this tool as given in the below script. The problem is that it works perfectly but it's not optimized plus it provides only a way to get rows by index which is why I was forced to use a…
2
votes
1 answer

The right API/scrape method to extract tables from a Qlikview app

I'm trying to get some tables with specific filters on this qlikview page, for future analysis: http://transferenciasabertas.planejamento.gov.br/QvAJAXZfc/opendoc.htm?document=painelcidadao.qvw&lang=en-US&host=QVS%40srvbsaiasprd01&anonymous=true I…
dll_ln
  • 23
  • 5
2
votes
0 answers

Qlik (view or sense) filter display data (X-axis) on a chart when using server-side extension

Hello Qlik experts! We have a unique challenge that we are trying to solve. We have a chart in our QlikView app that is displaying dates on the X-Axis and some measurements on the Y-Axis. Please look at the attached screenshot of the chart. The…
wntrsux
  • 123
  • 1
  • 1
  • 4
2
votes
1 answer

How to connect to Databricks Delta tables from QlikView?

I need to create QlikView Dashboard using data in databricks Delta Lakes. Has anyone tried connecting to DBFS using from a QlikView dashboard? I usually use JDBC connection string to connect to DBFS from my scala code. For that I use Spark Simba…
2
votes
1 answer

Assign multiple string to a single variable

I have a button which when clicked assigns values to a variable which is used for filtering within other charts. It works fine when i only assign one value but when i try to assign 2 values to the same variable it doesn't produce any data. The…
RobLaw84
  • 175
  • 2
  • 5
  • 18