ctrl+shift+p filters: :st2 :st3 :win :osx :linux


by inqlik ST3

Set of tools for QlikView development in Sublime Text 3


  • 0.1.49
  • github.​com
  • github.​com
  • 5 years ago
  • 53 minutes ago
  • 10 years ago


  • Total 5K
  • Win 5K
  • Mac 406
  • Linux 134
Jun 22 Jun 21 Jun 20 Jun 19 Jun 18 Jun 17 Jun 16 Jun 15 Jun 14 Jun 13 Jun 12 Jun 11 Jun 10 Jun 9 Jun 8 Jun 7 Jun 6 Jun 5 Jun 4 Jun 3 Jun 2 Jun 1 May 31 May 30 May 29 May 28 May 27 May 26 May 25 May 24 May 23 May 22 May 21 May 20 May 19 May 18 May 17 May 16 May 15 May 14 May 13 May 12 May 11 May 10 May 9 May 8
Windows 0 1 1 1 0 1 0 1 3 1 9 1 1 1 0 1 1 0 0 2 0 0 1 1 3 0 1 0 2 0 2 0 2 1 0 1 1 0 0 1 1 1 0 0 2 1
Mac 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Linux 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0



InQlik Tools for Sublime Text

Language plugin for QlikView load scripts

Syntax Highlighting

  • Both block comments (/* */) and line comments (//) are supported. CTRL-/ key combination comment/uncomment code block with line comments (//)
  • Variables, built-in functions and so on are trying properly show their boundaries by by coloring corresponding braces.
  • Nesting supported for all constructs - variable as parameter of function, function within function, function within variable and so on
  • Conflicts between some build-in functions and keywords (IF, LEFT, RIGHT, REPLACE) are resolving by context


In qvs files subroutine names, variables in variable assignment commands and table identifiers marked as symbols. So Goto Definition, Goto Symbol and Goto Symbol in Project commands work.

Goto file

You can open any file in your project's directories from within qvs script. Default keymap is Ctrl-F12. That is something like Open-include but it can properly open files when part of the path presented by qlikview variables (important in Qlikview Deployment Framework environment). It is useful for opening of include scripts, qvd files (in embedded metadata viewer), and so on.

Build System

Build system allow to batch reload of qvw file from within of corresponding qvs script file opened in Sublime Text. To run batch reload Sublime Text should be able to find corresponding qvw file. By default it will look up qvw file with same name as qvs script in same directory. For example: We are editing file c:\QvProjects\Project1\Apps\LoadData.qvs in Sublime Text. By invoking build system (keyboard shortcuts for this command are F7 or Ctrl-B) we effectively run shell command

c:\Program Files\QlikView\qv.exe /R /NoData c:\QvProjects\Project1\Apps\LoadData.qvw

Load script in your LoadData.qvw file should contain include directive pointing to LoadData.qvs, for example $(must_include=LoadData.qvs)

If qvw file stays in another directory it may be indicated explicitly in first line of qvs script file by shebang-like comment string. For example, if your script file is c:\QvProjects\Project1\Scripts\LoadData.qvs corresponding qvd-generator c:\QvProjects\Project1\Apps\LoadData.qvw would be found if qvs script has first line


You may also use relative path syntax and skip file part of path string if base names of qvs and qvw file are identical. So in our last example we with same effect may put in first line of qvs script


Ctrl-Shift-B key combination opens corresponding qlikview application instead of reloading it

QVD Viewer

Clicking on QVD file in project panel instantly open view with information available in qvd header and LOAD statement for that QVD

QVW.LOG file viewer

While you editing qvs script file Ctrl-Shift-L key combination or menu command Tools->Packages->InQlik-Tools->Open and refomat qvw.log file opens qvw.log file corresponding to currently edited script. If you open qvw.log file directly Ctrl-Shift-L key combination or menu command just reformat log file.

  • Output of qlikview script, including output from TRACE command are formatted as comment
  • Input commands are cleared from timestamp info
  • Syntax coloring is applied to input commands
  • Tables, variables and subroutine definitions are not added to list of defined symbols (Goto definition for example never jump to qvw.log file but to source qvs file)

Expression Editor: Language plugin for editing QlikView expressions and variables

Article about Expression Editor with downloadable sample project placed here and here

Expression editor used to write and store QlikView variables in convenient form. Expression editor use YAML like format.

Syntax highlighting

Expression editor highlight both syntax for it format and syntax of QlikView expressions edited.

Formats of autogenerated file

On every save plugin autogenerate external file in one of available formats:

  • Csv variable file in format used by QlikView Deployment Framework (by LoadVariableCSV subroutine). That is default option QDF.
  • Csv file in table format (option CSV), each row corresponds to whole expression and contains fields
    • Name
    • Definition
    • Label
    • Comment
    • Descirption
    • Section

Current export format can be changed at menu item Preferences->Packages Settings->InQlik-Tools->QlikView variables file settings: User

Mandatory tags:
  • LET or SET: precede name of expression. Corresponds to Variable field of standard QDF variable csv file
  • Definition: Corresponds to VariableValue field.
Optional tags:
  • Tag (exported as Priority field of csv variable file)
  • Description (exported as Comments field of csv variable file)
Optional tags exported as additional variables in QDF format (additional rows in csv variable file)
  • label
  • comment
  • backgroundColor
  • fontColor
  • nextFormat
  • enableCondition
  • showCondition
  • sortBy
  • visualCueUpper
  • visualCueLower
  • symbol
  • thousandSymbol
  • villionSymbol
  • billionSymbol

Usual minimal expression definition looks like

set: SalesSum
definition: Sum({<OperationType={Sale}>} Amount)
label: Sales
comment: Sales amount

And corresponding auto-generated csv file would be

SET SalesSum,Sum({<OperationType={2}>} Amount),,
SET SalesSum.Comment,Sales amount,,
SET SalesSum.Label,Sales,,


In qlikview-vars files expression names (name after LET or SET tag) marked as symbols. So Goto Definition, Goto Symbol and Goto Symbol in Project commands work for expressions.

Syntax checks

Minimal syntax checks provided: Checks for mandatory tags, checks for uniqueness of expression names

Expand variables mode

Given expressions

set: SalesSum
definition: Sum({<OperationType={Sale}>} Amount)
label: Sales
comment: Sales amount
set: CostSum
definition: Sum({<OperationType={Cost}>} Amount)
label: Cost
comment: Cost amount
set: MarginAmout
definition: ($(SalesSum) - $(CostSum))
label: Margin
comment: Margin amount

Expression MarginAmount defined in terms of expressions SalesSum and CostSum. Normally MarginAmount would be exported in same form to csv file. So in QDF format it would be

SET MarginAmout,($(SalesSum) - $(CostSum)),,

You can expand variables before export expressions (Menu command Tools\Packages\InQlik-Tools\Expand variables and export file or Ctrl-Shift-S key combination). So target expression in export file would be

SET MarginAmout,(Sum({<OperationType={Sale}>} Amount) - Sum({<OperationType={Cost}>} Amount)),,

Installation :

Using Package Control (Recommended)

For all Sublime Text 2/3 users we recommend install via Package Control.

  1. Install Package Control if you haven't yet.
  2. Use Ctrl+Shift+P then Package Control: Install Package
  3. Look for InQlik-Tools and install it.

Manual Install

  1. Click the Preferences > Browse Packages… menu
  2. Download zip package and extract its content into InQlik-Tools directory in this folder. (Check that README.md is immediately under InQlik-Tools' folder not in nested folder)
  3. Restart Sublime Text

Last changes


I've switched to ST3, further development will be focused on that platform. Basic functionality (syntax highlighting for qvs files and expression files) should work on ST2. Specifically QVD viewer does not work for ST2 and disabled explicitly in it.