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
256
votes
8 answers

Counting unique values in a column in pandas dataframe like in Qlik?

If I have a table like this: df = pd.DataFrame({ 'hID': [101, 102, 103, 101, 102, 104, 105, 101], 'dID': [10, 11, 12, 10, 11, 10, 12, 10], 'uID': ['James', 'Henry', 'Abe', 'James', 'Henry', 'Brian', 'Claude', 'James'], …
Alhpa Delta
  • 3,385
  • 4
  • 16
  • 31
13
votes
4 answers

Microsoft business intelligence platform vs QlikView

I have no experience at all with QlikView, but I have read great reviews about it. According to Gartner Research Report 2012, QlikView is in the top quadrant together with Microsoft, Oracle, SAP and IBM (leaders and visionaries). I am interested in…
AlejandroR
  • 5,133
  • 4
  • 35
  • 45
9
votes
1 answer

Qlikview Rolling 12 Month Fiscal

This forum seems to be more geared toward more programming issues but I would be interested if someone would look at the logic issue in the link below. My issue is about how to calculate the previous 12 months' total using the calendar already…
octopus_guy
  • 91
  • 1
  • 1
  • 3
8
votes
2 answers

Is Qlik Sense a new version of Qlikview or a new different product?

I've heard both scenarios from different sources and there seem to be some impression on Qlik's product strategy for the future. So, has someone understood if QlikSense is a new version of Qlikview or a new different product?
Krowar
  • 581
  • 2
  • 8
  • 18
7
votes
0 answers

Could not find a result for the specified execution ID

I am using QMC QlikView service for refreshing the documents. When I am calling the TriggerTask method of service, it is creating the task execution id successfully. But, with the same task execution id when I am hitting the GetEDXTaskStatus method…
Rahul Singh
  • 21,585
  • 6
  • 41
  • 56
7
votes
2 answers

Scripting language in qlikvew

As far as I understand, the following is a comment in qlikview //This is a comment 'This is not a comment Whats going on. I see a lot of VB script comments for qlikview on the net…
VivekDev
  • 20,868
  • 27
  • 132
  • 202
7
votes
4 answers

Handling multiple fact tables in Qlikview

I have a PostgreSQL database containing various education data such school-level test scores and enrollment figures. I need to separate enrollment from test scores because the data is on different grains. Even though enrollment is on a different…
5
votes
2 answers

How to make Excel a potent relational data source for manual entry?

I am using Excel to store data kind of as a relational database for data that will be entered manually (see my other question here : https://stackoverflow.com/questions/9416263/possible-solutions-for-simple-data-persistence-and-manual-entry) However…
5
votes
2 answers

Difficulties in installing Qlik Catalog related SW

I am installing Qlik Catalog SW on Linux Read Hat Enterprise 7.9 following the instructions of the installation guide. I have got the first problem in Tomcat Installation. Basically, I am not able to connect to Tomcat with the browser. Below is a…
user17157716
5
votes
1 answer

Qlik get distinct count from multiple fields

I've been scouring the net for over an hour and cannot find what I need. I have two columns that contain a persons name; Contact and Created By. Both are in identical format. Basically I need to count the distinct values of BOTH these columns…
Mark
  • 327
  • 1
  • 7
  • 14
5
votes
3 answers

Verpatch.exe error

I am trying to add new version resource string to .exe file using verpatch. I need to add new sting to version resource as I am creating test connector to Qlikview. For QlikView and Qlik Sense to be able to recognize an .exe file as a connector,…
Scooby
  • 71
  • 5
5
votes
1 answer

Is there a way to read Qlikview data object using R and perform an statistical operation and return results to Qlikview?

We are trying to build an application that can provide user the ability to chose an statistical operation using Qlikview, then load the data into R and perform the operation selected by user, and finally display the results using Qlikview. I'm using…
tanG
  • 71
  • 9
5
votes
1 answer

How to load an RData file with QlikView?

Is anybody aware of loading a RData file with QlikView? The reason why I would like to do this that I have a large dataset in R that I would like to analyse interactively with QlikView. Moreover, it takes very long to store the data with the…
Jochem
  • 3,295
  • 4
  • 30
  • 55
5
votes
3 answers

PHP PDO ODBC connection

we are trying to create a connection with our SQL database trough ODBC in PHP. This is our current script: $cnx = new PDO("odbc:Driver={EFR};Server=localhost;Port:7004;Database=EFR;Uid=LcLfVJFLTKTCEHRO;Pwd=*********;"); The driver is working in…
user2248551
  • 51
  • 1
  • 1
  • 3
5
votes
1 answer

How to sum a set of values that lie between a start date and an end date?

I have created two dropdown list 1. start date 2. end date I am using MySQL database as a source and I have a table called generation having columns like (date , generation, turbine_id). After selecting the start date and end date, I need to sum…
Ranjit Kumar
  • 779
  • 2
  • 8
  • 20
1
2 3
71 72