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