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
1
vote
1 answer

QlikView File not found error Cannot open file

I am trying to load data into QlikView Load Script. The file is an Excel file. First it loaded and then it returns the following message: File not found error Cannot open file: System error: Filesystem::FindEx non existing dir C
1
vote
0 answers

How to index a specific column to perform field comparison calculations?

Given the following table: | A | B | holdingtemp1 | holdingTemp2 | holdingtemp3 | holdingTemp4 | idx | | Grits| 7:06:24 AM | 180.199 | - | - | - | 0 | | | 8:35:56 AM | - | 174.30 …
1
vote
0 answers

Qlikview data export - Python

I'm not very knowledgeable on the subject ... I need to export a table from qlikviewer (where there is already a "Send to Excel" button). Initially I tried with Selenium, but arrived at the "second click" it does not find the text I need to filter.…
1
vote
1 answer

Join leaf nodes with respective parent nodes in qlikview

So I managed to get two node tables in which in one of them, I have the "tree" or structure of the nodes, and in the other table I have the last nodes of that table (Leaf nodes). I would like to make a full table where I have in Column 1, the…
Diego
  • 11
  • 3
1
vote
1 answer

Trying to implement nebula project is throwing an error: The splatting operator '@' cannot be used to reference variables in an expression

I am following the instructions on this page: https://qlik.dev/tutorials/build-a-chatbot-using-the-qlik-sense-natural-language-api I am actually getting an error which says the following: At line:1 char:5 npx @nebula.js/cli create mashup…
AOR
  • 11
  • 1
  • 7
1
vote
1 answer

Expression selection return the expression word not the whole row

I want to ignore the selection of a certain dimension in one expression, but still want that the table to be filtered for that dimension. Following example ID Project Project Lead 1 Dog Josh; Marc 2 Cat Sophie; Julian So when I…
user17156214
1
vote
1 answer

Array Pair Loading from databases using Qlik Sense

Does anyone has experience how to load/prepare data: [(1, 'a'), (2, 'b'), (3, 'c'), (4, 'd')] taken from SQL database (stored there as value) into qlik sense table: ID, Value 1, a 2, b 3, v 4, d
user17155772
1
vote
1 answer

How to get percentage Difference in qliksense

I need one help. I calculate a Difference Between Current Year Sale and Last Year like. num(Sum({$<[HSUBSEGM.descr]={"Clinker and Cement"}, [CALYEAR]={">=$(vCurrentYear)"}>}[_volume_SO]),'##.0')- num(Sum({$<[HSUBSEGM.descr] ={"Clinker…
user17145460
1
vote
1 answer

Qlik line chat expression

I have a table like this Month Customer Name Paid Collected Actual 1 John Smith 100 1000 10% 2 John Smith 200 1050 19% 3 John Smith 300 1100 27% 1 Kirk Polly 250 1150 22% 2 Kirk Polly 355 1200 30% 3 Kirk Polly 865 1250 69% The…
DATAMART
  • 29
  • 4
1
vote
0 answers

Qlik Desktop - Custom Connector - Error On ExtractQuery and other questions

I'm trying to develop a simple custom connector to Qlik, where I Get the data from a source specific, load the data in the Qlik and extract the data according own query. However, I found some problems and question, that I describe bellow: I pass…
Joao Pedro
  • 11
  • 4
1
vote
1 answer

in QLIK, how do I add data from table B to table A based on conditions in table A

still not completely understanding how to do certain things in qlik. I have a table payments, which includes a payment status, and a reference_key I have a table payment references which has a reference_key and a reference_number. payments has…
Darren Oakey
  • 2,894
  • 3
  • 29
  • 55
1
vote
1 answer

how do I create a qliksense app with multiple paramaterised instances

I'm brand new to qlik. I've been handed over a very complicated application with a lot of business logic that is constantly changing that can run against three different databases - ie dev/test/prod. Basically to decide which one it runs…
Darren Oakey
  • 2,894
  • 3
  • 29
  • 55
1
vote
1 answer

How to count Product ‘A-D’ without Null Value?

When I was trying to create a dashboard in Qlikview, I write a statement to show up the following product data in a bar chat: As you can see in the pic, however, the is a null value product to be counted. I write the following statement in the…
Ryan Ren
  • 23
  • 5
1
vote
1 answer

Qlikview aggregation

I have a table like the below. For each date there is a have a product. And I want to aggregate by the product and carry forward the total. But the total is limited to 0. For each day and product, I want to aggregate and carry forward the…
JonJon
  • 41
  • 4
1
vote
4 answers

Convert Qlikview Hex Date to Normal Date

I exported a XML file from Qlikview and the dates are in this 16-letter/digits form (i.e. 40E5A40D641FDB97). I have tried multiple ways to convert it to floating decimals and then dates but all methods have failed (incl. Excel HEX2DEC). Anyone has…