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 line chart

I have a table that looks like this Month Product Expected Actual Name 1 abc 10% 3% a 1 abc 10% 4% b 1 abc 10% 1% c 1 abc 10% 4% d 2 abc 20% 7% a 2 abc 20% 9% b 2 abc 20% 14% c 2 abc 20% 19% d I want to create a line chart…
DATAMART
  • 29
  • 4
1
vote
1 answer

Qlikview Scatter Plot

I'm trying to plot distinct values by date in Qlikview. How do I recreate the Excel scatter plot in Qlik? If there are multiple values per day I get an average value. I want to display all values on a given date.desired result
NancyG
  • 17
  • 2
1
vote
1 answer

Populating missing values in qlikview

I'm trying to populate missing values of the dates in between with peek function. I'm used the following code but still I couldn't get the results I'm looking for Table: LOAD * INLINE [ Date, Article, Quantity 01/02/2021, A, 10 …
walid
  • 13
  • 2
1
vote
1 answer

Qlik Sense Sum of One field based on unique value of other fields

Sample Data: P Q R 1 A 3 1 A 3 1 A 2 1 B 5 1 C 7 2 A 3 2 A 3 Expected Output: P Q R 1 A 5 1 B 5 1 C 7 2 A 3 i Have tried this Sum (Distinct R)…
Nandan
  • 91
  • 8
1
vote
1 answer

Merge duplicate rows with same values across two columns in my mysql table and add the values in third column

I have a data  table with 3 columns like below: Item1  Item2  Value Apple   Orange  3 Apple  Banana  2 Mango  Apple  2 Banana  Apple  6 Apple   Mango   5 Orange  Banana   4 Orange   Apple   5 I want to remove the duplicate rows based on the…
yaacoub Amna
  • 47
  • 10
1
vote
1 answer

Is there any way to change label names in Qlik Sense?

So I have a table with two columns: location name and coordinates. I created a map visualization using the coordinates and, of course, the labels on the side menu are the coordinates (as you can see in the pic below). Is there any way to change…
user14061418
1
vote
1 answer

Qlik sense concatenate and join are merging tables horizontally instead of vertically

I have the following 2 tables: [GP_BMI]: LOAD gp_event_id as all_events_event_bmi, gp_dataElement as gp_height_bmi_de, gp_de_value as gp_height_bmi_value, 'GP' as gp_height_bmi_stage Resident GP WHERE gp_dataElement='vOIPn23yOcr' AND…
alim1990
  • 4,656
  • 12
  • 67
  • 130
1
vote
0 answers

Linking quotation and order data in way that lets order data to be flexible

I have developed a data model as per screenshot. The purpose of this is to have all the relevant quotation data "mapped" out for further analysis. The data between orders/quotations/invoices etc is linked by generating link tables, which comes out…
DDoze
  • 53
  • 2
  • 9
1
vote
1 answer

Qlik Sense How to load a new table from existing one using for each loop when the source table is filled vertically?

I have a table with the following structure: The desired loaded table in Qlik Sense is as following: BY this structure, I will be able to add a table showing each doctor, and how many medications he prescribed, and even break it down into detailed…
alim1990
  • 4,656
  • 12
  • 67
  • 130
1
vote
0 answers

Qlik Sense API: Viewing data from a .qvf file in my Angular application

Alright, I'm new to working with the Qlik API and wanted to know if you can help me extract the data from a table from a .qvf file and filter it as if I were launching SQL queries or something similar. For now I show the data that a table contains…
Basuh
  • 31
  • 4
1
vote
0 answers

Grouping Multiple Rows into one Row

Here its my script to read stores QTY depending on ITEM SID, I need to group all records which are related to same ITEM SID to be merged together in one line, find below example images for result and expected results. SELECT…
1
vote
1 answer

Qlik: How to create dynamic custom segments?

I have a data source like this: ID Product Age 1 Amazon 18 2 Google 19 3 Facebook 20 4 Apple 21 5 Apple 22 6 Google 23 7 Amazon 25 8 Google 25 9 Facebook 27 10 Apple 29 11 Apple 28 12 Google …
Garfield
  • 143
  • 11
1
vote
3 answers

Can we deploy QlikSense on serverless architecture?

Can we deploy QlikSense/QlikView on serverless architecture? Currently using Monolithic architecture, any other way to move on to serverless?
1
vote
2 answers

Qlik Sense Script sekecting data based of a specific criteria

Sorry if I am missing something obvious as I am trying to learn Qlik Sense. I have a table with about 1 mil rows, I want to filter the data based the criteria below: Find the 1st Lost Charges for the serial Now switch the search to the serial +…
DDoze
  • 53
  • 2
  • 9
1
vote
1 answer

Qlik How to import JS Libraries that are Depended of ether other

I am building a custom extension and require Chartjs to do so. I have the following imports define( [ 'jquery', './PropertiesPannel', '//cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.3/Chart.bundle.js', …
Peachman1997
  • 183
  • 1
  • 12