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:  

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.

Do the following:

  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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?