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

How do I get the aggr of two aggrs in QlikView?

If I want to find the maximum value of a column from two states aggregated by a member's ID, should this work? =Aggr( MaxString( Aggr(NODISTINCT MinString({[State1]}DATE_STRING),MBR_ID) + Aggr(NODISTINCT…
Bret Walker
  • 1,796
  • 5
  • 20
  • 41
0
votes
2 answers

Error reloading a QlikView document via commandline in a macro

I have an issue with reloading a QlikView document. When I execute a batch file with the command: "C:\Program Files (x86)\QlikView\Qv.exe" /r "C:\QlikViewMount\reloadvictim.qvw" the document reloads fine. But, when I put it into a QlikView Macro…
0
votes
2 answers

Open File Dialog that Works with Win7

The old open file dialog that I used with QLikView no longer works on Win7. The sub used "MSComDlg.CommonDialog" and this was the code for the Sub. ' Sub to show open/save dialog SUB OpenSave (varOpenSaveInputBox, varOpenSaveType, varOpenSaveFilter)…
disasterkid
  • 6,948
  • 25
  • 94
  • 179
0
votes
1 answer

QlikView blocks Scripts folder for asp.net / mvc pages on same server

We have a brand new WinServer2k8R2 with IIS7.5. Asp.Net site on it would not display any javascript files. Narrowed it down to QlikView. When QlikView is installed on our server, it takes over the /Scripts/ folder on every website in IIS. Is there…
Ruskin
  • 5,721
  • 4
  • 45
  • 62
0
votes
1 answer

qlikview syntax - uniq key

I've an excel file with 4 fields :a,b,c,key. I need to check in QV script that for each row a,b,c there is only on key. The rows that have diffrent keys should be the result. for example this is an uncorrect situation that I need to catch : key | …
user1613935
  • 11
  • 1
  • 3
0
votes
4 answers

Inequality in Qlikview set expressions

Example from Qlikview help: sum( {$1978<2004”}>} Sales ) I try this code, but it did't works Count( {$Min(OtherDate)"}>} Damages.Id) Looks like qlikview did't support dates in inequalities. Any way if anyowne…
gabba
  • 2,815
  • 2
  • 27
  • 48
0
votes
2 answers

How to open a web page from QlikView?

I am starting to use QlikView. I need to open a web site from QlikView script, for instance something like call ("wwww.mywebsite.com"). Is possible to call a website from QlikView Script?
Ubalo
  • 749
  • 3
  • 10
  • 17
0
votes
1 answer

Variable Month mmm and Append to static text Field in SQL select Reporting design Studio 2005

I have a Budget table with field names "SSBJAN", "SSBFEB", "SSMAR", etc for the year My select query which works ok below, I currently change manually "SSBMAY" each month: SELECT SADIVO AS Division, SAWHSL AS Location, SSBMAY as BudgetSales, FROM…
0
votes
1 answer

How to make if condition for columns in excel with QlikView script

Here's the objective, I'm loading EXCEL files to QlikView, but I don't know their particular structure, all I need is if they got column, named 'Date'. How can I make 'if condition' for this
David Kakauridze
  • 305
  • 4
  • 11
  • 23
0
votes
2 answers

Rich iPad application using motion charts with flexible playback capabilities

What charting tool is the most promising to develop a rich iPad application that can display motion charts with replay capabilities? The end-user should be able to change what are being plotted on the x- and y- axes. In addition, can such…
user1304111
  • 1
  • 1
  • 2
-1
votes
1 answer

Qlik sense - Decile analysis with filter

I am using below logic from https://community.qlik.com/t5/QlikView-App-Dev/Decile-analysis/td-p/1223944. =Aggr( if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.1), 10, if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer),…
-1
votes
1 answer

Auto-increment/identity column in Snowflake table loaded by Qlik Replicate

I am loading data from a flat file (csv) into a Snowflake table using Qlik Replicate tool. In the Snowflake table, I have a column called "load_rec_num" to store something like ROWNUM of Oracle, that is, an auto incrementing numeric value as data is…
-1
votes
1 answer

Cumulative sum with condition

I wish to derive cumulative column based on initially adding the daily amount to the Value, then subsequently adding the daily amount to the resulting figure. Could you please help,…
-1
votes
1 answer

Qlikview Loop using distinct dates from data

i have data for sales of each product by date. I want to show the aggregated sale by product for each day. Please let me know if this is possible. Sample…
JonJon
  • 41
  • 4
-1
votes
1 answer

What are the ways to publish apps/sheets from Qliksense?

I have Sales database which contains sales data along with manager IDs, I have created the required reports in Qliksense and want to use Qliksense reports on custom UI (on an app).Also want to apply row level security so that one manager would be…