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

Extract Data from Qlik API using Python

I have a requirement where I need to fetch data from Qlik API in JSON format (just as we did in Power BI dataset) and parse it in CSV format. Essentially, attached is kind of data I'm trying to extract from Qlik Engine/QRS API. Anyway of achieving…
Dipanjan Mallick
  • 1,636
  • 2
  • 8
  • 20
-1
votes
1 answer

only get numberic value in qlikview

i have this kind of data - B-3-I11 B-3-I12 BI1-I190 BI1-I191 BI1-I192L BI1-I194A BI1-I195L BI1-I198R BI1-I199L BI1-I200Ac BI1-I201L conasde Installation Madqw Medsfg Woasd this is the data I have .. now I want only those which start from B and have…
-1
votes
1 answer

Execute QlikView file from task scheduler when there are no files in the folder

I need to run Qlikview file (.qvw) from folder A when there is a file in folder B. How to do it? Thanks! Inna.
-1
votes
2 answers

Migrate Qlik reports to azure

I did some research and found that there are some options to migrate on-premises QlikView reports to Azure data lake , using the IaaS approach. Is there an PaaS component for QlikView in Azure ?
MSTechnie
  • 175
  • 10
-1
votes
1 answer

Integration QlikView and python

How can I perform python Integration in QlikView or can anyone suggest me any blog for this or link?
-1
votes
1 answer

ODBC from QlikView to SQL fails on *first attempt*

I am running an ODBC from my QlikView server to SQL server to read some data. Every time I run the task that starts the reading it fails at the first attempt. When I run it the second time, it connects and works. Any ideas? Qlikview log…
Guy Bano
  • 1
  • 1
-1
votes
1 answer

QlikView Make button unclickable if no selections are made

I would like to be able to make my button unclickable / grayed out if no selections are made
Matt
  • 14,906
  • 27
  • 99
  • 149
-1
votes
1 answer

QlikView Expression that ignores some selections and contains where explicit values

I have a basic expression SUM(value). I want to modify this expression so it does 2 things: Ignores all list box selections except one (yearperiod) and contains explicit where conditions. Pseudo expected expression: (SUM(value) Where category =…
Matt
  • 14,906
  • 27
  • 99
  • 149
-1
votes
1 answer

Export whole Qlik report with Qlik extension

im working on a Qlik extension inside the Qlik extension editor. My goal is to export the current report as pdf and excel. I tryed to select the html code, format it and save as pdf first. This worked well since i noticed that just the displayed…
keschra
  • 289
  • 1
  • 3
  • 17
-1
votes
1 answer

set analysis expression distinct count with multiple exclusions

I am trying to display a unique count of people. There are multiple programs that the people could have been in, and some of them I don't want to be counted (they were only on a wait list). I've searched the internet and tried an if statement as…
Sarah Mc
  • 37
  • 6
-1
votes
1 answer

Qlikview load from excel specific row

I have excel and i need to import in qlikview wtih specific ruls. This is excel file excel file for import I need in one table to get data from row 1 to row 8 included 8, in second table to get data from row 9 to row 17... and so on to the end of…
stack
  • 35
  • 9
-1
votes
1 answer

Azure AD extraction script

Me (and the company I work for) are looking for a script to extract the following information from an AzureAD. Accountname Username Description creation date last login Blocked yes or no Date last password change Password expiration…
-1
votes
1 answer

How to loop data for the 4 last weeks

i want to store data per week per file. Actually we are on week 43. i want to have data for : week 42 stored in abc_42.qvd week 41 stored in abc_41.qvd week 40 stored in abc_40.qvd week 39 stored in abc_39.qvd here is the query used : SELECT…
-1
votes
1 answer

Show only nulls in a straight table in QlikView

I have a table with 2 columns, ID and NC. ID is unique and NC contains values (some values can be null). I need show only null values in a straight table. How can I do this?
-1
votes
1 answer

Convert number to Date in Qlikview macro

I read a number for example 42000 that I need to convert into date in the format DD/MM/YY in a macro, not a Load statement. In the macro the number is stored in vInput and the new value will be stored in vDate. Neither vDatet = Date(vInput,…