This example demonstrates various techniques to emphasize selected data while still keeping all data in view.

More information can be found in the blog post “Focus not Filter” .

Click image to enlarge

This example shows how the Aggr() function can be used to narrow or widen selections from a Calculated Dimension.

More on this topic can be found in the blog post  “Scoping Selections with Aggr“.

This tool builds a searchable repository of QlikView scripts.

Ver 1.9 Update:  Added optional “Search Words” file to search for a list of words during reload.

Ver 1.8 Update: Added a “Version 12 Upgrade Check” sheet to highlight potential QV12 script compatibility issues.

Each QVW file in the Input directory tree is opened and the script and module texts are extracted and written to the output directory. The QVWs are opened with /nodata, so the process runs quickly.

You must respond to any macro or section access login prompts.

After Reload, the extracted script can be searched using the “Script Search” sheet.

You must grant System Access to this QVW.

Follow the instructions on the “Main” sheet to get started.

After searching for “customer”

Click image to enlarge

An example file to accompany the blog post https://qlikviewcookbook.com/2017/09/qv12-alt-state-variable-fix/

This example file accompanies the blog post

https://qlikviewcookbook.com/2017/09/quick-sense-app-in-a-page/

This example accompanies the blog post “QDG Guru Day Inspiration“.  The example demonstrates using color encoding in a scatter chart to display two inter related dimensional series.

Click image to enlarge

Script Log Analyzer will analyze a set of Qlikview and/or Qlik Sense script  logs. It’s value is in visualizing the execution duration of each script statement in a reload.

Interface is available in English,  Portuguese, German and Spanish.

The v1.7 update fixes an issue where the last operation in a failed script was not accounted for.

The Qlik Sense version was written by Clever Anjos.

Click image to enlarge