Tools

Tools

AutoHotKey Script for Qlikview Editors

  AutoHotKey Script for Qlikview Editors
Version 1, Oct 29, 2014 - QlikView

This is a file for AutoHotKey (http://www.autohotkey.com/) that adds two shortcut keys to Qlikview expression and script editor dialogs:

Ctrl-4 : Bracket selected text with $()

Ctrl-[ : Bracket selected text with []

Copy Groups Utility

  Copy Groups Utility
Version 1, Apr 8, 2014 - QlikView

This utility copies group(s) from one QVW to another.

 

Click image to enlarge

DA Compare Tool

  DA Compare Tool
Version 0.9, Nov 22, 2016 - QlikView

This application is used to analyze and report on results from the Document Analyzer tool.

Input to this tool is the DocumentAnalyzerResults*.qvd files produced by Document Analyzer.

dacompare1

 

 

dacompare2

 

dacompare3

Click image to enlarge

QV Document Analyzer

  QV Document Analyzer
Version 3.2, Jul 19, 2016 - QlikView

This tool is used to analyze the structure of a qvw. The analysis focuses on what fields are used and where. This information can be to used to tune the performance of a Document or investigate the impact of data changes.

Changes for version 3.2

  •  Added Expression metrics to Summary sheet.
  • Added “Linked Object” property for Objects and [Linked Object] Listbox on Objects sheet.
  •  Removed background color from FieldName on Fields sheet, shown when the file has Recommendations.
  • Now capturing Labels assigned to Dimension fields. New property, [Dimension Has Label].
  • Now capturing Comment property of Dimensions and Expressions.
  • New properties, [Dimension Has Comment] and [Expression Has Comment].

 

Click image to enlarge

QVPR Analysis

  QVPR Analysis
Version 2, Apr 18, 2015 - QlikView

QVPR Analysis is a tool that will load a Qlikview XML Repository (QVPR) and allow you to analyze the contents.

With this app you can do Qlikview Analysis of the Reload and Distribution tasks defined on your server.

 

V2 Update adds Icon Graph visualization of task flow by Ralf Becher.

Click image to enlarge

QVS Editor

  QVS Editor
Version 1.2, Feb 5, 2015 - QlikView

This is a QVW used to edit external Qlikview script files — *.qvs & *.txt files — using the qlikview script editor. It’s useful in that it uses the actual script editor so you get all the features you expect – syntax, tabs, dropdowns, etc.


QVS Editor

 

Click image to enlarge

Script Log Analyzer

  Script Log Analyzer
Version 1.5, Jul 1, 2014 - QlikView

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

The v1.5 update adds translations for German and Portuguese.

Click image to enlarge

Script Repository

  Script Repository
Version 1.8, Jul 18, 2016 - QlikView

This tool builds a searchable repository of QlikView scripts.

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

Recipes for Qlikview Success