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

Data normalization / Searching across multiple fields

have some denormalized data, along the lines of the following: FruitData: LOAD * INLINE [ ID,ColumnA, ColumnB, ColumnC 1,'Apple','Pear','Banana' 2,'Banana','Mango','Strawberry' 3,'Pear','Strawberry','Kiwi' ]; MasterFruits LOAD * INLINE…
Dibstar
  • 2,334
  • 2
  • 24
  • 38
0
votes
1 answer

Qlikview aggration with conditions

I have some data like below - id, fn, ln, logdate 1, Rob, Hep, 01-04-2010 2, Rob, Hep, 09-04-2010 3, Rob, Hep, 10-10-2012 4, Rob, Hep, 01-12-2009 5, Peter, Cheng, 02-10-2010 6, bob, Pen, 05-10-2009 7, Peter, Cheng, 01-10-2009 8, Kim, Rany,…
Shashi
  • 199
  • 1
  • 6
  • 19
0
votes
1 answer

Qlikview Report for one Category with Charts that Contain Other Metrics

I am trying to create a report that all updates according to one location out of 35. In essence, I have 35 locations and so I will filter on one of the locations to update the whole report with data that relates to that location. However, there are…
user2662565
  • 509
  • 2
  • 9
  • 22
0
votes
1 answer

Zoomable scatter chart

In Qlikview 11 I managed to set up (amongst others) a nice scatter chart without any major problems. Now I would like to be able to zoom into a region in that chart. Intuitively this could be accomplished by selecting a rectangular region with the…
Sherlock70
  • 564
  • 10
  • 24
0
votes
2 answers

Cumulative SQL Table

I have an Excel file full of "Award Recipients", so like: Name | Date | Category John May-1 Fishing Mary May-2 Swimming Sue Jun-6 Fishing I am using this excel table as input into an SQL…
RodericDay
  • 1,266
  • 4
  • 20
  • 35
0
votes
0 answers

Incomplete loading from Google Cloud to Qlikview

We're trying to load a several million row table from Google Cloud into Qlikview but every time we've run the script to load it, the execution window stops prematurely loading only a fraction of the total table. Does anyone know if this is an issue…
0
votes
1 answer

OOP with PHP ( Webservices )

I am familiary with OOP in Java or .Net world, now I'm asked to work with OOP same in PHP in my company, but it seems total different, since in PHP we don't have strong type variables and I never did any OOP before in PHP. The task was actually to…
mike27015
  • 686
  • 1
  • 6
  • 19
0
votes
1 answer

Changing a QlikView document's zoom level programmatically

I know the following QlikView API methods: ActiveDocument.ActiveSheet.FitZoomToWindow ActiveDocument.ActiveSheet.ApplyZoomToAllSheets However, I want a method to change the zoom level to a chosen level, for example "Zoom to 75%". Is there any way…
Ramin Bateni
  • 16,499
  • 9
  • 69
  • 98
0
votes
1 answer

Application hang on reuse a qlickview ocx control when the control has encountered an error

My application has tow form 1) Main Form 2) Dashboard Form I used a qlickview ocx control on my "Dashboard Form" and i open my QVW files with this control and everything works fine.... But if my opened QVW document has encountered an error on…
Ramin Bateni
  • 16,499
  • 9
  • 69
  • 98
0
votes
1 answer

QlikView runs BodyOnLoadFunctionNames callbacks too early - why?

I have a problem with QlikView in the browser: I have a listbox and try to access it using an initialize script. The script is registered by using the InitWorkbench function, using its BodyOnLoadFunctionNames parameter. So far, this works, and the…
Golo Roden
  • 140,679
  • 96
  • 298
  • 425
0
votes
1 answer

Creating vertical and horizontal values for the median of the X and Y axis

I would like to display vertical and horizontal lines representing the median values of the X and Y values. These median values are in the data. This would divide the graph into quadrants. Is there any way to do this?
RVDowning
  • 73
  • 1
  • 2
  • 9
0
votes
1 answer

Encrypted an protected data for qlikview to consume

Have a lot of data in a database which I want different qlikview implementations to be able to consume. The data in the MS-SQL database is for several customers and I do not want to let them in directly in the db. I want to have an API where the…
Addeladde
  • 777
  • 2
  • 9
  • 28
0
votes
1 answer

Connecting QlikView With Abinitio and UC4

How can I most efficiently connect AbInitio with QLikView and UC4? I am familiar with the QVX option. Is What ist the interface between these two systems. (Description in German would use me better, but in English is also )
Adam
  • 2,347
  • 12
  • 55
  • 81
0
votes
6 answers

Google maps API v3 doesnt get the coordinates

this is my code in Qlickview: let noRows = NoOfRows('GoogleMaps')-1; for i=0 to $(noRows) let a=peek('CUSTACCOUNT',$(i),'GoogleMaps'); let b=peek('Adresa',$(i),'GoogleMaps'); Data: LOAD '$(a)' as [Kupac šifra], '$(b)' as…
user2220091
  • 3
  • 1
  • 4
0
votes
3 answers

How to call a big Stored procedure in Qlikview having 3 parameter

I have a stored procedure which contains 3 input parameters with multiple SELECTs and INNER JOINs. I want to Call the stored procedure in QlikView. I followed lots of tutorials, but I make it work. I am Using OLE DB and I'm trying to call as…
user2170314
  • 1
  • 1
  • 2