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

QlikView - Display datas from a field of a table

Can you help me to know, how can I display data in a chart only for a field of a table ? For example, I have a table "Country" which have "France, Allemagne, Italie, ...". In my chart, I only want to display datas from France, without any selection…
Olivierm67
  • 81
  • 1
  • 1
  • 8
2
votes
1 answer

QlikView diagram with relations between DB tables and QV objects

May be anybody know. Can I see via QlikView (something same to TableViewer) diagram with relations between my table in Db and QV objects (I mean tables which created in QlikView from qvd files).
Alex Shvarz
  • 124
  • 1
  • 11
2
votes
1 answer

Qlikview - calculate and use calculated variable in script

As a new Qlikview user, I'm looking for the best way to create calculated variables, and variables based on calculated variables, in my data and use them in displays. My data is connected via ODBC. For example, let's say I want a variable Rating…
MusicAndMath
  • 21
  • 1
  • 1
  • 3
2
votes
1 answer

Qlikview button make selection

I have a button that when it is clicked I want it to select the last 14 days. This means that if today's date is 2014-03-12, I want it to select all dates between 2013-02-26 and 2014-03-12. I have a time_table with the fields KEY_timestamp…
user1021726
  • 638
  • 10
  • 23
2
votes
1 answer

Automating qlikview charts using selenium

I am intending to automate the charts displayed in qlikview pages with selenium.As such charts are accessed as image as a whole in these pages its getting difficult to interact & locate specific elements/text on these charts. Qlikview Demo…
Shoaib Shaikh
  • 343
  • 7
  • 22
2
votes
2 answers

Qlikview guage chart - static variable

I am looking to create and use a gauge chart, but I am trying to figure how to compare selected vs the complete universe. For example, let's say I want to measure a monthly spending average of one department vs. the spending average of the entire…
Echo88
  • 21
  • 2
2
votes
1 answer

Qlikview Field dependencies

Is there a way to disable the field autocomplete in qlikview? For example, I have a document with 3 tables, and an object that has X fields, used for filtering data. My problem is that when selecting a value for a field, qlikview automatically…
Vlad
  • 536
  • 1
  • 5
  • 18
2
votes
0 answers

HTTP authentication on QlikView server from Java application

hello, I am developing a Java struts2 based application which is using QlikView as reporting tool. This application is using NTLM single sign on mechanism. when the user logs into the application and clicks on reports tab, he/she should see the…
Manish
  • 49
  • 1
  • 6
1
vote
1 answer

Qlikview chart sorting doesn't always work for users

I have several Qlikview charts that have interactive sorting enabled but the odd part is some columns can be sorted ascending or descending and others can only be sorted one way. Nothing happens if you click on the column again. Each field has a…
user1024285
  • 11
  • 3
  • 6
1
vote
2 answers

Qlik Sense: Sum by Distinct id

Generate sample data: SELECT 1 ID1, 1 ID2, 100 Amount FROM dual UNION ALL SELECT 1 ID1, 2 ID2, 100 Amount FROM dual UNION ALL SELECT 1 ID1, 3 ID2, 100 Amount FROM dual UNION ALL SELECT 2 ID1, 1 ID2, 500 Amount FROM dual UNION ALL SELECT 2 ID1, 2…
rhemmuuu
  • 1,147
  • 2
  • 5
  • 19
1
vote
1 answer

How to perform Partial Reload with Left Join on Qlik?

I have a Qlik script where I load two tables, Product and Customer. I join these two tables on a common field called Purchase_ID using a left join. I want to do a partial reload on the Customer table using the Partial Reload button to see the…
user42
  • 871
  • 1
  • 10
  • 28
1
vote
2 answers

Qlik Sense: Understanding what this summation expression does

I'm very new to qlik sense - I have some database experience. A team mate of mine recently quit who was the main owner of this piece of code. num(sum({1<[report_date] = {"=$(=(date((currDate))))"}> +1<[report_date]={"=$(date(currDate) - 7)"}> …
1
vote
1 answer

Uploading/Publishing Qlik Objects to Hub through Enigma.JS

I am currently trying to figure out a way to publish objects (charts/tables/variables/dimensions/etc) to the Qlik Hub from an application. I've been using Javascript, Enigma.js, and have been hosting the application on the same machine as the Qlik…
Matt K
  • 11
  • 2
1
vote
1 answer

What does "+1" mean in the following Qlik expression

I am assuming the following expression means sum of sales for year 2009 and country Sweden, but I am not sure why +1 is being used, is it used as separator or it has any special meaning? Sum({$+1} Sales)
1
vote
2 answers

How can I make a script in python to reload an app in qlik cloud

At this moment I'm trying to reload a Qlik app through a python script, but I had a few problems, I'm gonna explain the things I already tested, but if someone knows how can I solve that, I will appreciate it a lot The first thing I tried, was the…