Creating dynamic ad hoc analysis in QlikView

QlikView has some great tools to allow users to generate their own content. However, sometimes users don't want to learn those skills and would like to quickly just to be able to analyze data.

In this recipe, we will show how to create an easy-to-use dynamic analysis tool using some of the features from QlikView 11.

Getting ready

Load the following script:

// Set the Hide Prefix Set HidePrefix='%'; // Load the list of dimensions DimensionList: Load * Inline [ %Dimensions SalesPerson Country City Product ]; // Load the list of expressions ExpressionList: Load * Inline [ %ExpressionName Total Sales Order Count Avg. Sales ]; // Load the Sales data Data: LOAD * INLINE [ SalesPerson, Country, City, Product, ...

Get QlikView for Developers Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.