Skip to main content

Execute

The Execute statement is used to run other programs while Qlik Sense is loading data. For example, to make conversions that are necessary.

Note: This statement is not supported in standard mode. See File system access restriction

Syntax:  

execute commandline

Arguments:  

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.

Warning: If you set OverrideScriptSecurity to enable Execute, any user can execute files on the server. For example, a user can attach an executable file to an app, and then execute the file in the data load script.
  1. Make a copy of Settings.ini and open it in a text editor.
  2. Check that the file includes [Settings 7] in the first line.

  3. Insert a new line and type OverrideScriptSecurity=1.
  4. Insert an empty line at the end of the file.

  5. Save the file.
  6. Substitute Settings.ini with your edited file.
  7. Restart Qlik Sense Engine Service (QES).
Note: If 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