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

Reusability QlikView: Time/Calendar Table

It is important to apply calculations and business rules consistently across QlikView applications. We can store variables, connections etc. in an external file and apply them across various QVW. Is there a standardized script for time/calendar…
Adam
  • 2,347
  • 12
  • 55
  • 81
2
votes
0 answers

how to schedule a reload of a qlikview application after successful completion of ETL process which runs on Informatica in UNIX environment

We have Qlikview application ready. we are moving application to production environment. Now we need to schedule a reload of this application after successful completion of ETL process which is runs on informatica in unix environment. Any…
2
votes
1 answer

Tie R script and QlikSense software together

I require qliksense to create an Excel file when the user selects a set of tuples and R to automatically pick up this file, perform my script on the file. My script then creates another CSV file which I then want qliksense to automatically pick up…
jon doe
  • 87
  • 1
  • 6
2
votes
2 answers

How to avoid creating a date island in QlikView?

I'm a beginner developer and I have a database which has several different dates. Created Date Converted Date Lost Date Changed Date etc. The data needs to be shown in one application and filter on all dates. I am coding in QlikView and I could…
John
  • 21
  • 1
  • 3
2
votes
1 answer

How to retrieve all the columns from all of the tables in a particular database which are not part of primary keys and foreign keys

I am really new to Stackoverflow apologies for any mistakes. I am working on Qlikview. It doesn't allow the columns which are of same name in two different tables. I used to create aliases for each and every column every time when i need to import…
Munny
  • 67
  • 1
  • 10
2
votes
1 answer

Qliksense Extension - Select Values

I need to pass the value 'A' to be selected into a Qliksense extension. This extension contains 1 dimension and 1 measure. I would like 'A' to be selected in the 1 dimension. It seems that self.selectValues(0, 'A', false); is the call for this. I…
SwolleyBible
  • 243
  • 7
  • 20
2
votes
2 answers

Qlikview Exclude a value from a list selection box

I want to exclude a value from a list selection box. The field is called Status and there are 4 values All, Yes, No & Deleted. I want to NOT show All I tried this but it just renames it to 0 =IF(STATUS <> 'All', STATUS,0)
Matt
  • 14,906
  • 27
  • 99
  • 149
2
votes
3 answers

Count and distinct function

IF (A > 0, count (DISTINCT B)) If Variable A is greater than 0 then count variable B ignoring the duplicates with the use of distinct.
2
votes
0 answers

Interacting with QlikView using PhantomJS

I am trying to simulate traffic on QlikView dashboards for the purposes of load testing. I have created a number of simple dashboards that I am viewing in a web browser. When I click anywhere on a graph or select a field in a list box, I can see…
RyCSmith
  • 51
  • 5
2
votes
1 answer

Qlikview line chart with multiple expressions over time period dimension

I am new to Qlikview and after several failed attempts I have to ask for some guidance regarding charts in Qlikview. I want to create Line chart which will have: One dimension – time period of one month broke down by days in it One expression –…
jabree
  • 77
  • 3
  • 8
2
votes
2 answers

Passing external parameter to QV script

I am a newbie to QlikView and looking for some guidance on how to pass external parameter to qv script i.e qvw file. Below is the scenario on which I am working: We are creating a report for which the source is database and we will be using…
Explorer
  • 1,491
  • 4
  • 26
  • 67
2
votes
2 answers

How to select a particular number in a list box and make the other list box to only display the numbers greater than the selected number in QlikView?

I have two list boxes: Box1 and Box2. Box1 has values 10,20,30,40 etc and Box2 has the same 10,20,30 etc. After creating two separate list boxes for Box1 and Box2 respectively in the dashboard, how do I get to show only the values in Box2 which are…
2
votes
1 answer

Running Total in Qlikview

My table has the stock movement for each item by day. So at any point if I want to find the current stock, I need to sum all the stock movements from the day business started. Now I want to create a report which shows the stock level over a period…
2
votes
1 answer

Connecting Google Adwords with QlikView

I'm working in a project with Google Adwords and QlikView, the goal is to connect Adwords to QlikView so that I can import the data from Adwords to QlikView. If you have an idea to do this, please answer me.
ANAS89
  • 59
  • 1
  • 9
2
votes
2 answers

How to group time data into buckets in QlikView?

I have a list of times in QlikView. For example: 1:45 am 2:34 am 3:55 am etc. How do I split it into groups like this: 1 - 2 am 2 - 3 am 4 - 5 am etc. I used the class function, but something is wrong. It works but it doesn't create time…
Archid
  • 377
  • 6
  • 21