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

Qlikview: how to create summary table to filter multiple associated tables

I have 4-5 tables of single and many rows per ID. I want to generate a summary table listing each ID along with various counts and max/mins, but I want to be able to filter on calculations. Example: "ID" is the identifier and there are two tables,…
DaveA
  • 217
  • 3
  • 8
4
votes
2 answers

This site or IP is not authorized to use this API key

I am trying to render google maps with the following link inside QlikView application http://maps.google.com/staticmap?center=23.01,84.49&zoom=5&maptype=roadmap&size=640x400&key=XXXXXXXXXXXXXXXXXXXXXX&.jpg (I have created a BROWSER API key) The…
Adam
  • 2,347
  • 12
  • 55
  • 81
4
votes
2 answers

Looping and Qualify load in Qlikview

I want to create two tables in qlikview; one called Station and one called Trains. I had planned to apply a QUALIFY statement so any matching fields between the two tables are not confused. However, the data for each table are loaded in from…
Hal Baggot
  • 124
  • 2
  • 14
4
votes
3 answers

How do you increment a variable by +1 on a button click?

Hello kind helpful people, I am having a major problem in Qlikview. I am just trying to create a button that can increment a variable by +1 each time it is clicked. I thought i could simply write an expression on a button click event but Qlikview is…
Eddy Jawed
  • 457
  • 6
  • 17
4
votes
4 answers

QlikView application in web browser. How?

I am very new to QlikView. I have created a test QlikView application. I wonder, is it possible to access the application in a web browser? If yes, how?
mrd
  • 2,095
  • 6
  • 23
  • 48
3
votes
1 answer

Which NoSQL ... again :), but a different use case

Suggestions for a NoSQL datastore so that we can push data and generate real time Qlikview reports easily? Easily means: 1. Qlikview support for reads (mongodb connector available, otherwise maybe can write a JDBC connector, otherwise maybe can…
3
votes
1 answer

In qlikview , Is it possible to keep the script window always open?

During the code development it would be better if I could reload my code and keep the script window open. At the same time it would have to allow me to change or creat objects on my dashboard. Is this possible ?
3
votes
2 answers

Python integration in Qlik on MacOS

I'm very new to using Qlik and at the moment I've only used the cloud via my browser. I would like to integrate python and Qlik such that I can run my code on data in the QlikCloud and visualize using Qlik. I am using a Mac, therefore I can not…
Emily
  • 354
  • 3
  • 10
3
votes
2 answers

Which gives better performance for connection with Qlikview??SQL server or SSAS Cube?

I want to process my data into Qlikview but i am confused about to process the data through Cube or directly from SQL. Can anyone tell me which gives better performance from cube and SQL? Note: I have millions of data into the database.
Crystal
  • 45
  • 8
3
votes
2 answers

Doing Crosstable in Pandas like in Qlik?

I have a dataframe: df1=pd.DataFrame({ 'ID':[101,102], 'Name':['Axel','Bob'], 'US':['GrA','GrC'], 'Europe':['GrB','GrD'], 'AsiaPac':['GrZ','GrF'] }) Which I want to change to this: …
Alhpa Delta
  • 3,385
  • 4
  • 16
  • 31
3
votes
1 answer

Using Qlik with Webpack 1

I'm using webpack 1 to try and import an external js file, written in the amd module pattern, from a product called Qlik, which does visualizations. The project uses angular-fullstack yeoman generator, so the webpack config file is:…
Eric C
  • 832
  • 3
  • 8
  • 20
3
votes
0 answers

QMSClient.SaveCALConfiguration doesn't seem to be working

Can anyone help me understand why this below would not remove named cals. It seems to work fine until the very last line where it does the save. I don't get any exceptions or error messages. When i look in QV Management console under…
ska.dev
  • 169
  • 1
  • 9
3
votes
2 answers

Filtering by a calculated measure involving multiple fields in Qlik Sense

I am trying to use a calculated measure as a way to filter my data, but it's looking more difficult than expected. Let me explain through an example. I have data of the following type, with two dimensions - one is a unique ID, the other a category -…
etste
  • 55
  • 1
  • 2
  • 7
3
votes
4 answers

Button object in Qlik Sense

How can I use a button object in Qlik sense the same way it is in Qlikview? Qlik Sense has no button object in the default objects as it is in Qlikview. Thanks in advance! Ziad
Ziad Salem
  • 496
  • 13
  • 34
3
votes
2 answers

Using version control systems with QlikView

I'm new to QlikView and want to use some version control systems (such as Git) in order to track changes. I am however not sure exactly how to do this, because at first sight it seems to me that the .qvm files contain both code and data. As a…
Geir
  • 514
  • 4
  • 18
1
2
3
71 72