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

Splitting the Filed Name (Table's Header) into Two Separate Lines

I have a dataset of the following structure: Company.ID DDR (25632) PTL (89567) 2512 89 74 9875 78 96 7892 14 73 I would like to split the header into two different lines. With other…
And_R
  • 1,647
  • 3
  • 18
  • 32
1
vote
1 answer

QlikView add Calculated Dimension within a Table

Hi Guys I am trying to create a table in Qlikview that shows me sales starting from current week (Week 11) and works back Week 10 Week 9 etc to week 52 previous year. I can do this by creating individual expressions but this would be extremely time…
PA060
  • 59
  • 1
  • 7
1
vote
1 answer

List Box for Aged Inventory by Days

I want to filter my list box to where it only shows Items for 1-7 days, 8-14 days, a month and so on. How would I go about doing this? I am new to Qlikview but have some minor experience with coding so I figured I would use a If Then statement I am…
1
vote
1 answer

How to create a stacked bar chart with multiple columns on Qlik

I am trying to create a stacked bar chart on Qlik from a dataset shown below. The chart should look like a picture below. (I apologize about the quality). I watched a couple of tutorials, but their dataset had a different organization... Should I…
Tak
  • 167
  • 1
  • 5
  • 18
1
vote
1 answer

Qlik View Google Map Extension Template error

I am new to the Qlik View tool. I have embedded an extension called Google Maps API v3. I have supplied the API Key in the configuration. But Still, when i select the longitude and latitude, it refreshes but the location is not changed in the map.…
Siddharth
  • 45
  • 6
1
vote
2 answers

Connecting 3rd party reporting tools to MySQL

I have an application that runs on a MySQL database, the application is somewhat resource intensive on the DB. My client wants to connect Qlikview to this DB for reporting. I was wondering if someone could point me to a white paper or URL regarding…
Skyboard
  • 51
  • 2
1
vote
1 answer

Qlikview URL parameter selection not working due to cache

I am trying to embed a Qlikview chart in a custom webpage via an iframe - using singleobject.htm. I want to apply a certain filter so i am passing "&select=LB186,CSP" where LB186 is the listbox in the actual qlikview document. This "select"…
Preeti Joshi
  • 841
  • 1
  • 13
  • 20
1
vote
1 answer

Qlikview Format textbox expression as percentage to 3 decimal places

I am trying to show percentage increase / decrease based on week number for 2018 v 2019 with an expression in a textbox in Qlikview: Here is my expression: = num(Sum({}Retail) - Sum({
PA060
  • 59
  • 1
  • 7
1
vote
1 answer

Histogram of aggregated dimension in QlikSense?

A simple, but yet frequent statistics is a histogram of derived entity, and if I understand the official QlikSense documentation right that seems not working out of the box: You cannot use a master dimension that was created using the …
B--rian
  • 5,578
  • 10
  • 38
  • 89
1
vote
2 answers

Bookmark a variable value in Qlik Sense

Is there a way to bookmark an input box value in Qlik Sense ?. I know there is a way to do this in Qlik View in Document Properties but wondering how do I achieve this in Qlik Sense. Any help appreciated. Thank you.
SVK
  • 1,004
  • 11
  • 25
1
vote
1 answer

Get count of multiple files loaded in one statment

I want to get a total amount of all rows in multiple files, which are saved as a QVD. Actually, with one file I would accomplish this like that: data: LOAD count(id) AS counter FROM data.qvd (qvd); LET number = Peek('counter'); Of course, I know…
Julian Schmuckli
  • 3,681
  • 11
  • 37
  • 64
1
vote
2 answers

Exclude Value form Dimension

I have this set analysis sentence: =if(aggr(Rank(Count(WordCounter)),Word)<=70,Word) I have a request to remove "Among" from the Word data. Any suggestion?
Pablo Gûereca
  • 725
  • 1
  • 9
  • 23
1
vote
3 answers

Failed to open document in QlikView

I have problem with opening a QlikView report. I did a document in QlikView and then I closed it, now when I try open it again this message appeared: " DOCUMENT X.qvw failed load" enter image description here Does anyone know what cause such a…
Willy0147
  • 21
  • 1
  • 2
1
vote
0 answers

Simple QlikView Mashup (iframe embed) - why does it work with anonymous?

https://help.qlik.com/en-US/qlikview-developer/November2017/Subsystems/Mashups/Content/mashups-start.htm The above article discusses ways in which we can embed QlikView components (via iframes) in our own external website. I've proven this with a…
user10058046
1
vote
1 answer

how to get the script from an qlikview qvw file?

i try to get the script as string from an local qvw file. i created a simple windows-form-application and add a reference to my local qlikview desktop installation so i can access the object model. QlikView.Application QVApp; …
codeslave
  • 13
  • 6