Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using EXECUTE statement.?

Hi,

When using Execute statement/keyword to run a file upon reload, I get the following error:

Execute_Error.png

1. Execute C:\audio.mp3
2. Execute D:\Sampletext.doc;

I see nothing wrong with the syntax. Kindly suggest.

Regards,

-Khaled

1 Solution

Accepted Solutions
Not applicable

This will open a specific .txt file with notepad - the execute format is program (space) file

EXECUTE C:\WINDOWS\system32\notepad.exe C:\Documents and Settings\ep1285\Desktop\test2.txt;

Regards,

Gordon

View solution in original post

9 Replies

Hi,

     This may be because of the security settings.

     Check with the security settings and set it as Allow System access.

Celambarasan

Not applicable

Hi,

Marking the check box Script(Allow Database Write and Execute Statements) found under User Preferences>Security worked.

Thanks,

-Khaled

Not applicable

Hi,

Although that works, I still cannot open anything that's not an application.

For example, the first and the second statements do not work while the third works.

1. EXECUTE C:\Users\Developer\Downloads\playbook_white1.jpg;

2. EXECUTE C:\Users\Developer\Desktop\Ex_EXECUTE\123.txt;

3. EXECUTE C:\Program Files (x86)\Internet Explorer\iexplore.exe;

Kindly suggest.

Regards,

-Khaled.

Hi,

     You need to open the image in windows picture viewer?

     if so try with this

   EXECUTE  rundll32.exe shimgvw.dll,ImageView_Fullscreen C:\Users\Developer\Downloads\playbook_white1.jpg;

Hope it helps

Celambarasan

Not applicable

This will open a specific .txt file with notepad - the execute format is program (space) file

EXECUTE C:\WINDOWS\system32\notepad.exe C:\Documents and Settings\ep1285\Desktop\test2.txt;

Regards,

Gordon

View solution in original post

Not applicable

...forgot to add that the script will pause until the file is closed - is this what you want to do?

Not applicable

Hi,

Thanks, Yes, I wanted to open the image in some photo viewer..

Although, the script execution dialog display 'Execute.......jpg done',it does not open the image. I have verified the paths for both the photo viewer and image.

Regards,

-Khaled

Not applicable

Hi Gordon,

Thanks. Yes, wanted to ask that already...

Just wanted to open an app using execute and the script should automatically continue/complete execution. Instead, it pauses script execution until the file/app is closed. I guess there must be a work around.

Regards,

-Khaled.

Creator III
Creator III

‌anyone where is this setting in Qlik sense