topic Re: Run qvw from batch in QlikView

Run qvw from batch

PrashantSangle — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need your help in windows command to execute qvw files.

I have below scenario.

I have 4 qvw file say a.qvw,b.qvw,c.qvw and d.qvw. Here I need set dependency.

If one of the qvw failed to reload then execution of other qvw must stop.

I have also notice if we run single qvw through batch and if it failed to reload then qv.exe is not getting close.

I need your help to resolve above 2 issue.

To run qvw through batch I am using below command

C:\Program Files\QlikView\qv.exe /r D:\Document.qvw

I have refered below thread

QlikView Desktop client command line‌

Let me know if any questions

Thanks and Regards,

Re: Run qvw from batch

syukyo_zhu — Wed, 15 Jun 2016 13:31:46 GMT

Hi,

Try do it on your script

execute cmd.exe /c ""C:\Program Files\QlikView\Qv.exe" -r "..\..\application\a.qvw"";

execute cmd.exe /c ""C:\Program Files\QlikView\Qv.exe" -r "..\..\application\b.qvw"";

Re: Run qvw from batch

jonathandienst — Wed, 15 Jun 2016 13:35:34 GMT

Create a bat file like this:

C:\Program Files\QlikView\qv.exe /r D:\a.qvw

IF %ERRORLEVEL% NEQ 0 (

exit /b 1

)

C:\Program Files\QlikView\qv.exe /r D:\b.qvw

IF %ERRORLEVEL% NEQ 0 (

exit /b 2

)

C:\Program Files\QlikView\qv.exe /r D:\c.qvw

IF %ERRORLEVEL% NEQ 0 (

exit /b 3

)

C:\Program Files\QlikView\qv.exe /r D:\d.qvw

Re: Run qvw from batch

jonathandienst — Wed, 15 Jun 2016 13:39:16 GMT

You can set the ErrorMode in the model to prevent stopping on an error

ErrorMode 1 (default) - stop on error with option to stop or continue

ErrorMode 0 - ignore error

ErrorMode 2 - terminate failed on error

Re: Run qvw from batch

syukyo_zhu — Wed, 15 Jun 2016 13:46:32 GMT

Yes of cause,

But i think this isn't necessary in this case.

Re: Run qvw from batch

PrashantSangle — Wed, 15 Jun 2016 14:23:42 GMT

Hi Sir,

can you elaborate what below command do in above script

exit /b 1

Thanks and Regards,

Re: Run qvw from batch

tamilarasu — Wed, 15 Jun 2016 14:47:36 GMT

Hi,

exit [ExitCode]

EXIT -> Quits the CMD.EXE program or the current batch script.

/b -> Exits the current batch script.

ExitCode -> Specifies a numeric number. If /B is specified, sets ERRORLEVEL that number. If quitting CMD.EXE, sets the process exit code with that number.

An exit code of 0 means success and 1 or greater means failure.

Re: Run qvw from batch

qlikviewwizard — Wed, 15 Jun 2016 14:50:43 GMT

Check this Batch file script to reload Qlikview Applications

Re: Run qvw from batch

marcus_sommer — Wed, 15 Jun 2016 15:24:58 GMT

A further possibility would be to use vbs-macros instead of command-lines, something like this could be a starting point: Re: Vbs - passing parameters to opendoc or opendocex.

Another way could be to create parameter-files which contain only some text like run/stop or successful/failure or as a variable or a table which are evaluated from the following task-steps. I use such constructs mainly to control OnOpen trigger in QV and Excel but it should be also possible to control various dependencies with these method - whereby I like the suggestions from Jonathan and would start with them.

- Marcus

Re: Run qvw from batch

tamilarasu — Wed, 15 Jun 2016 15:46:11 GMT

You can also create a batch file like below,

"C:\Program Files\QlikView\qv.exe" /R "D:\a.qvw" || GOTO:eof

"C:\Program Files\QlikView\qv.exe" /R "D:\b.qvw" || GOTO:eof

"C:\Program Files\QlikView\qv.exe" /R "D:\c.qvw" || GOTO:eof

"C:\Program Files\QlikView\qv.exe" /R "D:\d.qvw"

Re: Run qvw from batch

PrashantSangle — Thu, 16 Jun 2016 06:32:06 GMT

Hi,

Thanks marcus_sommer‌.

Your replay also helpful for me, but I don't want to write any macro or modify existing qvw.

So I tried solution suggested by jontydkpi‌. and It is working fine but I need few more modification in suggested solution.

But it gives me pretty much much good start.

Thanks and Regards,

Re: Run qvw from batch

PrashantSangle — Thu, 16 Jun 2016 06:37:59 GMT

Hello Sir,

Your script working fine but If qvw failed to reload then qv application not getting close.

Is there any command which will forcefully closed qv and exit batch on if qvw failed to reload.

Kind Regards,

Re: Run qvw from batch

marcus_sommer — Thu, 16 Jun 2016 06:59:21 GMT

I'm not sure if you could call a quit- respectively kill-statement per macro-function within the script (quit shouldn't work because it needed an ActiveDocument which doesn't exists during the load) but from external vbs-batches (see attachment) triggered from an EXECUTE statement might work.

- Marcus

Re: Run qvw from batch

PrashantSangle — Thu, 16 Jun 2016 09:49:21 GMT

Hi Sir,

Using Jonathan solution I found working solution.

step 1 : in QVW i have

set ErrorMode=0; // to make sure qv will closed.

step 2 : used script provided by Jonathan

and It works for me.

In this 2 day I learn so many new things.Thank you all for your guidance.

Thanks and Regards,

Prashant

Re: Run qvw from batch

Karim_Khan — Wed, 21 Aug 2024 11:55:47 GMT

Hi Prashant,

I am trying to execute the batch with same approach but its getting autclosed.

Is there some access related stuff you have taken while executing the batch?

Regards,

Re: Run qvw from batch

Karim_Khan — Wed, 21 Aug 2024 12:23:52 GMT

This command is running infinitely

Re: Run qvw from batch

Karim_Khan — Wed, 21 Aug 2024 12:40:27 GMT

I got the solution after making small adjsutemnt in my script.

Thanks @PrashantSangle @ jontydkpi‌. for your support.