The Execute statement is used to run other programs while Qlik Sense is loading data. For example, to make conversions that are necessary.
Syntax:
execute commandline
Arguments:
| Argument | Description |
|---|---|
| commandline |
A text that can be interpreted by the operating system as a command line. You can refer to an absolute file path or a lib:// folder path. |
If you want to use Execute the following conditions need to be met:
- You must run in legacy mode (applicable for Qlik Sense and Qlik Sense Desktop).
-
You need to set OverrideScriptSecurity to 1 in Settings.ini (applicable for Qlik Sense).
Settings.ini is located in C:\ProgramData\Qlik\Sense\Engine\ and is generally an empty file.
Do the following:
- Make a copy of Settings.ini and open it in a text editor.
- Insert an empty line.
- Type OverrideScriptSecurity=1.
- Save the file.
- Substitute Settings.ini with your edited file.
Example:
Execute C:\Program Files\Office12\Excel.exe;
Execute lib://win\notepad.exe // win is a folder connection referring to c:\windows
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!