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.

Information noteThis functionality is not available in Qlik Sense SaaS.
Information noteThis statement is not supported in standard mode.

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 noteIf 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).
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