The Execute statement is used to run other programs while Qlik Sense is loading data. For example, to make conversions that are necessary.
Information noteThis statement is not supported in standard mode. See File system access restriction
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.
Information noteIf Qlik Sense is running as a service, some commands may not behave as expected.
Example:
Execute C:\Program Files\Office12\Excel.exe;
Execute lib://win\notepad.exe // win is a folder connection referring to c:\windows