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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
