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
1 answer

Chart color with selection and drills

I have a bar chart with some values and 2 dimensions. I put these 2 dimensions in a group. Now I'd like to control the colors si I go in expression tab, click on the "+" and add a ondition for the background color. This is the code I use to control…
Verd'O
  • 101
  • 1
  • 10
2
votes
2 answers

TOTAL vs Aggr in QlikView

I'm trying to understand how TOTAL and Aggr work in QlikView. Could someone please explain the difference between the two examples below, and if possible please illustrate with a SQL query? Example1: Max({} Aggr(Sum({
user3476463
  • 3,967
  • 22
  • 57
  • 117
2
votes
0 answers

What is CServerDocumentEntry and Why is It Erroring?

Im receiving hundreds of errors each day due to this error. Its happening within the Application Server Logs. Can someone explain it and maybe how to solve it? CServerDocumentEntry: Could not fetch modified time for [APPID]. Skipping newest check.
SpoiledTechie.com
  • 10,515
  • 23
  • 77
  • 100
2
votes
2 answers

Convert date format qlikview

My date is in the form of 31/01/2017. I want to format it as 31-Jan. How do I do it? This doesn't work. There is an error. =date(date#(=maxstring({[Date1]} [DATE]),'DD/MM/YYYY'), 'DD-MMM')
Ninja Dude
  • 1,332
  • 4
  • 27
  • 54
2
votes
1 answer

Conversion of a stacked bar chart to a 100% proportional stacked bar chart

I am currently working on a dashboard to analyze the job market in Singapore. I made a stacked bar chart for job functions vs career level. My supervisor asked me to create a proportional stacked bar chart to see the clear difference in ratios of…
Raj
  • 171
  • 1
  • 1
  • 8
2
votes
1 answer

Qlik Sense : Editing User Access

I am new to Qlik Sense and has been assigned task to divide users into two sets. User Set 1 : These users can Create App, Load data, Create data models and create sheets over data model. User Set 2 : These users can only Create and view sheets…
2
votes
0 answers

Google Map in QlikView

I'm trying to create google map in QlikView for dashboard creation. The version of QlikView I use is 12.10. I use the following code for main: SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; SET MoneyDecimalSep='.'; SET…
User1493
  • 481
  • 2
  • 7
  • 23
2
votes
1 answer

Qlik sense - Rank() within a specific dimension when you have multiple ones

I am new to Qlik and trying to solve the following issue. I have a table with two dimensions, one with the entry's unique ID, and one with a category, as in the example below. Table example My goal is to create a new column with a ranking of 'Score'…
etste
  • 55
  • 1
  • 2
  • 7
2
votes
1 answer

SQL equivalent query in Qlikview?

In SQL we can write query like: Select field1,field2,field3,field4,field5,field6,field7 from table1 t1,table2 t2,table3 t3 where t1.field1 = t3.field3 and t2.field2 = 'USD' In Qlikview, I have created QVD's for 6 tables, now I want to create…
Mogli
  • 1,972
  • 11
  • 34
  • 67
2
votes
1 answer

Zoom in combined chart (Pareto) not working in QlikView 11

I have a combined chart (Pareto) and what I am trying to do is zooming the selected area by dragging and dropping mouse pointer but it is not working. However I have another line chart and it is working.
Willy
  • 9,848
  • 22
  • 141
  • 284
2
votes
3 answers

Qlik Sense, Counting distinct with a sum

I am trying to create an expression in qlik sense to get the count the distinct number of ID's where each prod is added up and is greater than 0. Qlik sense expression so far, but wrong: sum(aggr(count (DISTINCT ID), PROD1 + PROD2 + PROD3 )) …
Heathenry
  • 21
  • 1
  • 5
2
votes
3 answers

Qlikview, Conditional based on number of rows in straight table

So in Qlikview, I am trying to make a conditional that would only display the table if the table has less than 50000 rows. How would I go about to doing this? The table I am working with is used for the user to create their own reports. They are…
siddhu
  • 369
  • 1
  • 6
  • 16
2
votes
1 answer

Combining two fields

in one of my charts I have Branch as the dimension and the expressions are a set of KPIs. I also have a Year (2009-2016) list box that is set up to always have one selected value. From 2014 onwards I need to amalgamate Branch A into Branch B while…
2
votes
2 answers

How to interface Python with Qlikview for data visualization?

I am using Scikit-Learn and Pandas libraries of Python for Data Analysis. How to interface Python with data visualization tools such as Qlikview?
User456898
  • 5,704
  • 5
  • 21
  • 37
2
votes
1 answer

How to manually edit keys for XML load statements?

I want to load two xml files. They are using the same xsd. Because of differences in file content, the QlikView xml wizard creates different table structure for load statements. By manual edits in the XML load statements I have managed to load both…
LudvigH
  • 3,662
  • 5
  • 31
  • 49