O'Reilly logo

QlikView for Developers Cookbook by Stephen Redmond

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required