topic Execute Statement for Qlikview Scripts in QlikView

Execute Statement for Qlikview Scripts

Thu, 11 Jul 2013 22:40:19 GMT

Hi all,

I'm trying to figure out if there is a way to execute Qlikview scripts from ANOTHER Qlikview script. I have a large number of scripts that need to run either daily/weekly/monthly, and it's quite tedious to have to open each module and reload the script.

Is there a simple command that executes a given script so that I can house a large number of execute statements in one file? Any help would be much appreciated.

Thanks,

Paul

Re: Execute Statement for Qlikview Scripts

swuehl — Thu, 11 Jul 2013 23:30:58 GMT

You can start QV from the command line and use the reload switch to reload your document, save and close the document. Please check the chapter in your reference manual (AFAIR 7.1 and 7.4).

I would recommend creating some windows batch files to execute these reload tasks and maybe create a windows schedule to run them.

[I assume you don't have a QV server available for scheduled reloads]

You can also execute a windows command from within the script (check also the HELP or fe manual), like

Execute cmd.exe /C C:\BatFiles\Script.bat

Re: Execute Statement for Qlikview Scripts

Fri, 12 Jul 2013 13:54:59 GMT

Do you have a link to that reference manual? 7.1 and 7.3 in the reference manual I found don't appear to deal with any sort of script execution.

http://community.qlik.com/servlet/JiveServlet/previewBody/1794-102-1-1791/QlikView%20Reference%20Manual.pdf

I'll do some research on creating batch files to execute each of my scripts - thanks for the idea!

Re: Execute Statement for Qlikview Scripts

swuehl — Fri, 12 Jul 2013 14:04:03 GMT

Well, that's the reference manual for version 10. Current version is 11.2.

But the content is not much different, just look into chapter 6.1 and 6.3 of the linked manual.

Re: Execute Statement for Qlikview Scripts

Fri, 12 Jul 2013 14:05:17 GMT

Awesome, thank you.

Re: Execute Statement for Qlikview Scripts

Fri, 12 Jul 2013 16:01:23 GMT

I'm new to creating batch files; could you help me with the syntax? I have something that looks like this:

@echo off

REM execute script

C:\Users\Paul\Desktop\qv.exe /r C:\Users\Paul\Desktop\Test.qvw

It's not loading anything, and I know it's something really close to this. Any ideas?

Re: Execute Statement for Qlikview Scripts

swuehl — Fri, 12 Jul 2013 16:17:39 GMT

You have installed QV to your desktop? Can you start the desktop client from there? Can you open your application just by using

C:\Users\Paul\Desktop\qv.exe C:\Users\Paul\Desktop\Test.qvw

in a shell?

If above is not the real path, usual suspects are spaces in the path, try quoting your pathes, then.

Re: Execute Statement for Qlikview Scripts

Fri, 12 Jul 2013 16:18:09 GMT

Figured it out! Here it is:

start "" "C:\Program Files\QlikView\Qv.exe" /r "C:\Users\psokolik\Desktop\Test.qvw"

Re: Execute Statement for Qlikview Scripts

Fri, 12 Jul 2013 17:56:29 GMT

You mention:

"You can also execute a windows command from within the script (check also the HELP or fe manual), like

Execute cmd.exe /C C:\BatFiles\Script.bat"

Does the execute statement within the QV script need to refer to a batch file? If not, I assume I could have script A execute script B with a simple execute statement at the end of the file (and start a chain effect with script C, D...).

If it execute statement in the QV script DOES need to refer to a windows batch file, I assume I can just have the batch file command be to execute the next script in the chain (Script A calls batch file to start script B, script B runs and calls batch file to start script C, etc.)

Which is best?

Re: Execute Statement for Qlikview Scripts

swuehl — Fri, 12 Jul 2013 18:58:23 GMT

No, you don't need to call a batch file, so you can potentially just start the next qv.exe job (haven't tried this, would be interested in if you succeed).

I see one potential issue here:

If you execute a second QV script from the first, the first will not finish until the second does. If you are using a chain of several large QVW, you end up with having all of them open.

While this could still work, this might cause performance issues as well as having the risk of losing all reloaded QVW when something happens at the very end.

Re: Execute Statement for Qlikview Scripts

Fri, 12 Jul 2013 19:28:54 GMT

Thank you so much for the help. If that's the case, it may not be my best option.

I've already tried putting several execute commands in a single batch file (I arranged them in the order I want them executed), but it seems to cause issues with file access and sharing. I'm not exactly sure how batch file commands execute, but it appears that they either execute all at the same time, or simply send the command to QV and don't wait for a "reload complete" indicator. When I run the batch file, I usually get an error or two saying that "File B can't execute because File A is running" or something of that sort.

I need to think of a slick way to make sure the scripts execute in order, one after the other. I was thinking about putting a sleep function between each command so it waits to execute the next file for a specified amount of time, but I don't know what that time should be, since it will vary.

If you can think of anything, let me know. Again, thanks for the help.

Re: Execute Statement for Qlikview Scripts

swuehl — Sat, 13 Jul 2013 00:00:55 GMT

Ah, forgot to mention that you can indeed run your programs without waiting on each other (which then may result in access violations), if you want to synchronize the executions in sequence, I think you need to use 'start /wait /b' or something like this (check the help for start), or just removing the start command should do the same.

Just search the Web for command line program execution.

Regards,

Stefan

Re: Execute Statement for Qlikview Scripts

Anonymous — Mon, 26 Aug 2013 14:28:31 GMT

Dear All,

i m facing this issue wherein i m unable to call the 2nd Qlikview Application

Please find the below code which i used to call the 2nd Qlikview Application

Code Script:-

Let vNextBatchFile = 'D:\Application\test_appln_2.bat';

execute cmd /c $(vNextBatchFile);

Above statement executes successfully but the Application doesn't reload.

Script under "test_appln_2" batch file

"C:\Program Files\QlikView\Qv.exe" /r "D:\Application\test_appln_2.qvw"

Could anyone please assist me.

Thank you,

Girish Chhatani