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

Qlikview REST connector pagination settings for OData source xml

I can't seem to get the pagination settings right for the Qlik REST connector getting data from an OData-source. It's publicly available Dutch statistics (CBS). An example is: https://opendata.cbs.nl/ODataFeed/odata/37259ned/TypedDataSet First bit…
1
vote
1 answer

Assign Null (missing) values on section access reduction

Suppose I have the following very simple data warehouse: section application; car: LOAD * INLINE [ CAR,USER GETZ,George ]; person: LOAD * INLINE [ USER George Maria ]; As you can see, USER George has a CAR GETZ, while USER Maria has no car. Is it…
George Menoutis
  • 6,894
  • 3
  • 19
  • 43
1
vote
0 answers

SVG MAP extension

I am developing a dashboard with a map from australia using the SVG MAp extension for qlikview. In qlikviewdesktop works correctly: but when I load the report to the server and review it from the portal it doesnt show anything and actualy the…
Pablo Gûereca
  • 725
  • 1
  • 9
  • 23
1
vote
0 answers

Qlikview OLEDB Connection string missing out values when ODBC works fine with the same extract file

OLEDB Connection string missing out values when ODBC works fine with the same extract file. I have a simple extract file with 1 query: QUALIFY *; MyQVTable: LOAD *; SELECT * FROM MyTable; STORE MyQVTable INTO $(vQVDDirectory)\MyQVTable.qvd; DROP…
Matt
  • 14,906
  • 27
  • 99
  • 149
1
vote
2 answers

INTERSECT OPERATOR in set analysis qlikview

QLIKVIEW DEVELOPERS: I am creating a set analysis. sum({}sales) sum({}sales) What is the role of * in the second expression? both the expressions are resulting the…
1
vote
1 answer

Qlik sense+restrict values in pivot table

I have the following data set (only that it's on a larger scale): LOAD * INLINE [ Region, Value, Quarter A, 1, Q1 18 B, 2, Q1 18 C, 3, Q1 18 D, 4, Q1 18 A, 1, Q1 17 B, 2, Q1 17 C, 3, Q1 17 D, 4, Q1 17 A,…
rosuandreimihai
  • 656
  • 3
  • 16
  • 39
1
vote
1 answer

Show Customer Orders that also had orders yesterday

I am trying to create a formula that will show all orders for customers that have an order yesterday. So if the customer has an order yesterday, show all orders for that customer but if a customer has no order yesterday then show nothing. This is…
djblois
  • 963
  • 1
  • 17
  • 52
1
vote
1 answer

Set analysis not working as intended

I'm creating a dashboard for a school project, and I just came to the conclusion my set analysis is not working correctly. I have a funnel chart with the turnover of the employees who are working at the company for less than 20 years. I have this…
Frankicks
  • 29
  • 9
1
vote
1 answer

Qlik View 9 versioning Git

I'm trying to version my QlikView 9 app. So I should create a folder with the same name as .qvw file I intend to version adding -prj suffix. My app name is app.qvw. In the same folder a new folder app-prj is created. When I save the app normally…
Gabriel
  • 17
  • 6
1
vote
1 answer

Reload data from Excel by end users in QlikView

I have a script like this: INPUTFIELD Amount1,Amount2; Fact: LOAD * INLINE [ Group,Sales, A,345 B,12 C,45 D,56 E,79 F,12 g,12 h,12 h,4 ]; Fact1: LOAD…
green user
  • 77
  • 1
  • 2
  • 10
1
vote
0 answers

Expression chart colors depending on the dimension for no selected values

I was planning to do a Straight Table chart like this: The four dimensions should always appear and have exactly the same colors (the only variation is the expression values). What I have now is the dimensions and the values as I want except for…
1
vote
2 answers

QS: Find the sheets that use the master item

I have many sheets in Qlik Sense and I need to modify the name of a master measure. How can I find all sheets/visualizations where that master measure is used? So I know what will it affect.
adlisval
  • 341
  • 1
  • 7
  • 17
1
vote
1 answer

Using Excel File for Variables in Qlikview says File not found

In my company we are using an excel file to store our expressions and variables so we can update them in one central location and we use multiple tabs (in qlikview tables) to keep them organized. I didn't like the duplication of code, so I created…
djblois
  • 963
  • 1
  • 17
  • 52
1
vote
2 answers

Conditional expression to obtain resource

I need an expression for showing either green up arrows or red down arrows; it'd look something like this: if sum(Revenu) - Sum(BudgetAmount) > 0 green up arrow (else) red down arrow This is what I'm trying to show: How would I do this?
Vicky Mani
  • 11
  • 1
1
vote
2 answers

The QVW File Size Is Larger While Using Cube Data

I've made two QlikView (two .qvw files) reports which have almost the same content. One loads data from Data Warehouse using 'Microsoft OLE DB Provider for SQL Server'. Another one load data from Cube using 'Microsoft OLE DB Provider for Analysis…
soxmomomo
  • 33
  • 3