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
2
votes
2 answers

Qlikview macro to automatically Fit zoom to window

How can i create a macro to automatically Fit zoom to window. I cant see an options to do this via a trigger. Preferably i would like this macro to be triggered when the screen resolution changes, if not possible i would like it to be set when you…
Matt
  • 14,906
  • 27
  • 99
  • 149
2
votes
2 answers

Qlik View: Get Values WHERE (value2 = max)

i have a relativly simple problem: i have a Dataset that consists of an id(not for entry but for specific object), an age of the object and a power value. So what i get is a lot of entries where there is a power at a specific age for a specific…
Julian
  • 915
  • 8
  • 24
2
votes
1 answer

Set a default sheet (tab) when opening a qlikview file

How to set a default sheet (tab) when opening a qlikview file? I have multiple tabs and would like the document to always open on a specific tab
Matt
  • 14,906
  • 27
  • 99
  • 149
2
votes
1 answer

Selected Dimension Value in Expression in QlikView

Just wondering how to get a selected value in an expression. I have the following bar chart, with drill down from Year to months. When I click say 2011 bar I get the following chart. Now is there a way to get Transported Mail - 2011 in the second…
VivekDev
  • 20,868
  • 27
  • 132
  • 202
2
votes
1 answer

How to sum three columns in qlickview (two from table1 and one from table2)

I need to create a 4th column in either table as a sum of columns 1,2 and 3. How can I do it?. LOAD column1, KeyColumn FROM [C:\Qlik\file1.xlsx] (ooxml, embedded labels, table is sheet1); LOAD column2, column3, KeyColumn…
jotape
  • 319
  • 2
  • 6
  • 14
2
votes
3 answers

Limit dimension values displayed in QlikView Pivot Table Chart

I have a pivot table chart in QlikView that has a dimension and an expression. The dimension is a column with 5 possible values: 'a','b','c','d','e'. Is there a way to restrict the values to 'a','b' and 'c' only? I would prefer to enforce this from…
user3652812
  • 91
  • 2
  • 3
  • 8
2
votes
2 answers

QlikView "field not found" workaround for adding a new field

I am trying to get my script to reload in QlikView without success. I have added a new field (named Litres) to my most recently generated QVD files. However, my older QVD files do not have this Litres field which therefore causes the script to error…
bexlynam
  • 23
  • 1
  • 3
2
votes
1 answer

QlikView Text Object Formatting

I am unable to format the text in a text object. For example, I need headers in bold, while the body of the text could be normal. Can I get any hints on this? I know this can be achieved via extension objects, but I do not have any experience…
user2703591
  • 41
  • 1
  • 8
2
votes
1 answer

Including description texts in QlikView Reports

How to include large text description in QlikView Dashboard Reports to ease the visualizations of the users? Can anybody suggest an example on this ? Thanks
user2703591
  • 41
  • 1
  • 8
2
votes
1 answer

Qlikview set analysis with multiple conditions

I have the following set analysis with one condition. =sum({1} bank_shr_bal)/1000000 I need to create a second condition that filters the months the data collects from. The date column needs to be greater than a variable created called "minusYear"…
user3264602
  • 157
  • 2
  • 4
  • 12
2
votes
1 answer

Connect Amazon S3 to QlikView to pull data

I have a Hadoop job which is executed on a daily basis. This then generates a text file which is then stored on Amazon S3. I wish to pull the same data into QlikView. Is there any way by which I can perform the task?
Naresh
  • 5,073
  • 12
  • 67
  • 124
2
votes
2 answers

QLikView escape character for special characters in Calculated Dimension

In a calculated dimension in Pivot Table, I would like to have special characters, in particular a single quote character inside a string in quotes. More precisely: I would like to have in a calculated dimension a pick(match('Val1',…
kiriloff
  • 25,609
  • 37
  • 148
  • 229
2
votes
1 answer

Qlikview - Use selected value from listbox in another listbox

I have two date fields I'm using in listboxes: DateCreated and DateCompleted. This information is related to maintenance work order tasks. When I select a date in the DateCreated listbox I have a text box with an expression which gives me all the…
dan1974
  • 245
  • 3
  • 5
  • 8
2
votes
3 answers

Interactive chart sorting in Qlikview

I have a barchart in Qlikview where my x-axis is set by a selection (using a calculated dimension) to be either date or station. Is there a way for the sort order to be defined by the selection of x-axis. Specifically, I would like the chart to…
Hal Baggot
  • 124
  • 2
  • 14
2
votes
1 answer

Representing a nested stacked bar chart

I'm a QlikView beginner and I'm working with a piece of data; trying to visualize it as a bar chart. More specifically, I need to develop a nested stacked bar chart as shown in the image. At a top level, for every project, I need to have the…
Spottsworth
  • 395
  • 5
  • 12