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

Problem with the data of an axe in a graph

I have build a graph in qlikview with the data, all the nessacery has been done but the data of the orizental axe are confused.
Fatiso
  • 59
  • 8
1
vote
1 answer

two expression at 1 time in qlikview

I have 2 different expression in qlikview and i want to use these both expression at in 1 measure first expression =if(P_No_1=SubField([P No.],'-',1), 'Renew','Lost') second expression =If(Len(Old_Policy)=0 and Year(Today())=[Year], 'New' ) now…
MIRROR
  • 61
  • 1
  • 2
  • 10
1
vote
1 answer

QlikView - How to use "set" in "edit script" during loading process

I am trying to load a field that has numbers from 1 to 12. But I want the equivalent month name to be loaded into Qlik View. Like Instead of 1 I want the cell to contain Jan and instead of 2 I want it to be Feb etc.,Everywhere people are suggesting…
Pal
  • 173
  • 2
  • 16
1
vote
1 answer

Days from dates in qlikview expression

I am trying to get days from given data like this: In this data suppose ID B start date is 4/10/2019 and end date is 10/25/2019. Here there is 7 months: April to October, so for the first month start date is 4/10/2019 and end date is 4/30/2019 so…
MIRROR
  • 61
  • 1
  • 2
  • 10
1
vote
2 answers

AVG of the last 7 days not returning results

I have an expression to give me the AVG of TIMETAKEN in the last 7 days but it isn't returning any results. =AVG({}TIMETAKEN) I can get yesterdays AVG with this and it…
Matt
  • 14,906
  • 27
  • 99
  • 149
1
vote
1 answer

Qlikview use IN rather than = in a variable in an expression

I have a variable in an expression that SELECTS bottles. sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] ={'Bottle'}>}[Amount]*-1) I would like it to be able to select where RCPT equals bottle OR laptop.
Matt
  • 14,906
  • 27
  • 99
  • 149
1
vote
1 answer

QlikView expression for last 12 months & DISTINCT & not changed by selections

I have a few expressions: =COUNT(SUPP) Gives me 9316 which is correct as it is the total number. =COUNT(DISTINCT SUPP) Gives me 3429 which is correct as it is the total distinct number. =ROUND(Sum( if((Date(MonthName(MMMYY),'MMM-YY')) >=…
Matt
  • 14,906
  • 27
  • 99
  • 149
1
vote
0 answers

Differences between Qlikview and SQL query results

I have Qlikview installed on my pc and it takes the data from a database. I want to write an sql query which would take the same data(for automatization). The problem is that my sql query returns 30+k more records than Qlikview. I believe, that…
milka1117
  • 521
  • 4
  • 8
  • 17
1
vote
1 answer

How can I connect REST API (Java) from QlikView?

I want to connect REST API from QlikView and create chart/table view based on the JSON response from the REST call. Instead of connecting MySQL datasource and database Is it possible to connect REST API and get the JSON and then generate chart/table…
Gnik
  • 7,120
  • 20
  • 79
  • 129
1
vote
2 answers

How can we connect multiple data sources in QlikView?

I want to connect multiple data sources (Oracle, MySql etc) and databases. Then I want to create a table in Qlikview based on the result set of multiple select queries from the different databases. How can we do this?
Gnik
  • 7,120
  • 20
  • 79
  • 129
1
vote
1 answer

Less than or equal to date in set analysis

I am trying to sum values where the week number is less than or equal to the current week. It works if i just want equal to current week but not if i want less than or equal. This is what I've tried but nothing…
RobLaw84
  • 175
  • 2
  • 5
  • 18
1
vote
0 answers

Create custom button in Qlikview

Is there any possible way that I can create my own custom button? Something like creating a button in Photoshop with a specific extension and then using it inside Qlikview in a correct way, or a button object just like the others Qlikview already…
jvbs
  • 417
  • 2
  • 11
  • 27
1
vote
1 answer

Macro to generate xlsx works fine manually but not from the batch through QlikviewManagement Consol

I am trying to export few charts to Excel (.Xlsx format) through Qlikview Macro and to save it on postrelaod at a particular location. The file works perfectly fine when it is run manually or from the batch (.bat) on double click. But when scheduled…
1
vote
2 answers

Qlik Sense: how to specify path in Google Drive?

I have a Google drive account divided into some folders (say, Folder1, Folder2, etc.), with some subfolders in it. I successfully managed to connect my Qlik Sense app to it. I need to make it look for files only in a given subfolder. At the moment,…
SamCle88
  • 275
  • 3
  • 9
  • 22
1
vote
2 answers

Stuck at Getting Survey Details from SurveyMonkey REST Connection in QlikSense

I'm trying to connect to the Survey Monkey API via a hard coded connection set in a variable but the connection is giving me such error: QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 400 (Bad Request): { "error": { "docs":…
Giõ Hb
  • 11
  • 1