Execute command does not work

[draghici1109]

Hello,

I want to execute some commands on operating system using the execute command and yet I do not get it executed. I get the message:

EXECUTE statement requires Script (Allow Database Write and Execute Statements) in User Preferences settings
EXECUTE cmd.exe/c chdir C:\Users\wkiv1150\Desktop\BICC\08226000-00-02\DATA

Here is my code:

set vPath = "C:\Users\wkiv1150\Desktop\BICC\08226000-00-02\DATA";
EXECUTE cmd.exe/c chdir $(vPath);
Execute cmd.exe/c findstr /V /R "FeldFesteLaenge" Artikel-Stammdaten_SAP.txt > Artikel-Stammdaten_SAP1.txt;
EXIT SCRIPT;

I set the properties of the tab as follow:

[Or]

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptR...

It looks like you may have missed some steps.

[draghici1109 · Accepted solution]

Thank you! Indeed I missed following settings on my desktop QlikView:

Do the following:

• On QlikView Desktop Start Page, click the Settings drop-down menu and select Users Preferences...
• On the Security tab, select Script (Allow Database Write and Execute Statements) to enable the security override.

Information noteThe Script (Allow Database Write and Execute Statements) setting must always be enabled if you want to allow Execute statements in the script.
See: User Preferences: Security

• Open the QlikView document in which you want to perform the Execute statement, and open the Script Editor by selecting Edit Script... from the File drop-down menu.
• In the lower part of the Script Editor window, go to the Settings tab and select Can Execute External Programs.