A set of Enigma scripts for extracting and converting strings in Qlik Sense apps to translation expressions.

• Read: Extracts strings that can be converted to epxressions to CSV file
• Write: Converts strings to Qlik expressions =$(Translate('Any string'))
• Undo: Restores converted expressions back to strings

The main bat file runs all scripts and merges the csv files into one.

• Install enigma.js
• Install minimist npm i minimist
• Download zip file and extract to folder

• Start Qlik Sense Desktop
• Open command prompt
• Run bat file

Usage:   .\qStrToExpr.bat <read|write|undo> <appname>
Example: .\qStrToExpr.bat read LabelExtract

The scripts can alo run individually:

Usage:   node getset_masteritems_filterpanes.js -m=read/write/undo -a appname
Example: node getset_masteritems_filterpanes.js -m=read -a LabelExtract

• Tested on Qlik Sense April 2018.
• Modifies the data structure of the app, might break in older or younger versions.
• Make a copy of the app before running the script.
• Only strings that can be expressions in the UI is handled.
• LabelExtract.qvf is a example app with strings, LabelExtract_expr.qvf is the same app after conversion with strings as expressions.

• Sheet: title and description
• Object: title, subtitle, footnote, dimension label, alternative dimension label, measure label, alternative measure label, chart totals.
• Object include barchart, boxplot, combo chart, distribution plot, filter pane, gauge, histogram, KPI, line chart, map chart, pie chart, pivot table, scatter plot, table, text box, treemap, waterfall and extensions.
• Masteritems, same as objects plus master item label and description.

The script can be used as a starting point for producing a multi lingual Qlik Sense app. The example Sense app contains a link to a Google Spreadsheet that contains the string index and auto translated strings =GoogleTranslate($A2,$A$1,B$1) to a number of languages. More info on the subject on translating apps Handling Multiple Languages by Charles Bannon.