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
2 answers

How to SELECT a column twice from the same table in sql to show different value?

I want to show different value in Qlik sense dashboard, but I have to use same column from same table in SQL - how can I do this? Here is my code: "first" LOAD WORKORDERID As ID, REQUESTERID as RqId, TITLE As Subject, SQL SELECT…
Pooneh.T
  • 9
  • 1
  • 4
-1
votes
1 answer

Color Coding KPI using Set Analysis and simple comparison functions (Qlik)

New Qlik Sense/ Qlik View user here. I want to create a KPI, where the conditional coloring will filter based on two fields: EstArrivalTimeHrMinSec [Estimated time taken for an Ambulance to arrive at Incident scene (Predicted…
-1
votes
1 answer

Get value to max date

I have a problem on on Qlikview. I would like to get the associated value of the max date when I select and ID. For example, if I have the following data: id value date 1 2 1 1 4 2 1 6 3 1 5 4 When I select ID=1 I would like…
-1
votes
1 answer

Qlikview: How do I limit chart (straight table) lines to calculated values?

I have a problematic table, which is interconnected and goes out of memory often, but I've limited it to show 50 items, but now want to limit it to show only lines that one column calculated. The calculation - one price minus another one. I need to…
Vaidøtas I.
  • 544
  • 7
  • 23
-1
votes
1 answer

List all available apps from Qlikview and Qliksense?

Our organization is using both qliksense and qlikview, and as such, getting to all of the available apps (hopefully this terminology is right - I'm new to this - each report, which I think is called an app) that a user might have access to is…
dgwebb
  • 321
  • 3
  • 16
-1
votes
3 answers

Qlikview: tablebox or straight/pivot which would show minimum value and related value of the min value

This is driving me nuts. Say I have a mass of lists with product names, their prices and the origins of the pricing: Product, 1$, USA Product, 2€, EU Product, 0.5€, HK What is the correct table configuration to get this result, without duplicating…
Vaidøtas I.
  • 544
  • 7
  • 23
-1
votes
1 answer

Connection between R and qlikview with opencpu

I want to create connection between R and QlikView using 'opencpu' package R. I've seen some examples but I did not understand how to use the opencpu R package to create the connection between R and QlikView.
-1
votes
1 answer

QlikView: Find the next date prior to the currently selected date

I have a series of dates, eg.: 20160628 20160627 20160623 20160620 If I select a particular date, I want to find the date immediately prior to that date. For example: If I select 20160628, I get 20160627. If I select 20160627, I get…
PingPing
  • 899
  • 6
  • 15
  • 28
-1
votes
1 answer

Create QVD File using tool

How can I create qvd file using Qlikview, or using an other tool and how can i use qlikview using that file
Nina PRO
  • 91
  • 2
  • 13
-1
votes
1 answer

Query showing a result like 0 when the site is down or not responding

I have the following query loaded in Qlikview that returns results from a website (works fine) but I want to display a result when, for example, the site is down or not responding (something like else or if null). LOAD Server as…
Malbordio
  • 92
  • 3
  • 4
  • 20
-1
votes
1 answer

Load multiples files with different headers

I've succeed to load data from multiple files using this script: SET ThousandSep=' '; SET DecimalSep=','; SET MoneyThousandSep=' '; SET MoneyDecimalSep=','; SET MoneyFormat='# ##0,00 €;-# ##0,00 €'; SET TimeFormat='hh:mm:ss'; SET…
Thomas Ayoub
  • 29,063
  • 15
  • 95
  • 142
-1
votes
1 answer

Sort chart in qlikview

Hello I did sort in my chart but it doesn't work, i don't know why?
Nina PRO
  • 91
  • 2
  • 13
-1
votes
1 answer

How to hide graph in qlikview

I want to hide a graph in qlikview, display it when I want, but not delete it. Your help is very appreciated Thank you
Nina PRO
  • 91
  • 2
  • 13
-1
votes
1 answer

If expression in Qlikview

My expression: IF(Min(MONTHYEAR) > Min(MONTHYEAR2) and isnull(FIELD1),FIELD1B,if(Min(MONTHYEAR) > Min(MONTHYEAR2) and len(FIELD1)>0,FIELD1)) as Value I need this: 1.-if(Min(MONTHYEAR) > Min(MONTHYEAR2) and isnull(FIELD1) output…
ANOUK_prog
  • 27
  • 6
-1
votes
1 answer

QlikView data sourcing from MySQL server on Linux via SSH

How do we define ODBC for MySQL database running on Linux machine (AWS) for which we have to connect using SSH? Basically, I have to get the data loaded into QlikView file. So I am not able to figure out do the connection settings.