topic Re: Reload options in QlikView

Reload options

Tue, 26 Jun 2012 04:16:06 GMT

Hi All,

I have created two Qlikview applications both use the same QVD's files.

whats the best way to reload this applications ...

The procedure i am fallowing right now is

First the QVD generator app is reloaded based on daily scheduling option in QMC.

Then after an hour both the Qlikview applications are reloaded daily

Is it possible to run the Qlikview applications after the Successful reload of QVD generator file ?

Also could someone help what is Batch execution and how to achive this?

Thanks

Re: Reload options

Tue, 26 Jun 2012 04:48:51 GMT

hi Monica,

their are two options to do this.

1) if u have publisher licence then u can schedule the application sequentially or parallely through teh trigger option in the server settings.

2) if u don't have the publisher u can schedule the applications for reload through the Batch files.

you can put the applications in sequence of reload in batch file and if u want two applications to reload parallely u need to schedule two batch files each.

u need to write the following code in Notepad

"C:\Program Files\QlikView\Qv.exe" /r "ApplicationPath\Sample.qvw"

and then save this notepad at .bat extension.Then schedule this batch file in the windows schedular/OS Schedular.

Re: Reload options

Tue, 26 Jun 2012 05:00:52 GMT

Hi Prathiba,

We have only Qlikview server, could you provide more details where the bat file needs to be stored and how to run it

Thanks

Monica

Re: Reload options

Tue, 26 Jun 2012 05:15:08 GMT

Monica,

Open a notepad and copy the below line in it, but do replace the Application path with the path of ur application.

"C:\Program Files\QlikView\Qv.exe" /r "Application path\Sample.qvw"

"C:\Program Files\QlikView\Qv.exe" --->> is the path of teh QV.exe

/r -->> is command to reload teh application

"Application path\Sample.qvw" -->> place the path of the application in place of Application Path,

Suppose your application name is Sample.qvw and its in D drive of ur system,thn the command will be:

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

Now save this notepad as .bat extension like "abc.bat" where abc is the name of ur batchfile with extension .bat .This will create ur batch file.

And then schedule the abc.bat file in teh TAskSchedular of your system at the time when u want it to get reloaded.

PLace one more line below the

"C:\Program Files\QlikView\Qv.exe" /r "D:\Sample.qvw" line ,with the name of teh aplication changed as:

"C:\Program Files\QlikView\Qv.exe" /r "D:\Sample2.qvw" where Sample2.qvw is another application that u want to get reloaded after thge complete reload of Sample.qvw.

so ur batch file will be having below to line:

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

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

which will load Sample.qvw at scheduled time and after the reload of Sample.qvw, the Sample1.qvw will be reloaded.

I hope this will help you.

Re: Reload options

Tue, 26 Jun 2012 07:39:00 GMT

And Double click on the batch file to run it.it will open a dos prompt till the time the application is getting reload and will close automatically.

Re: Reload options

rwunderlich — Tue, 26 Jun 2012 16:19:01 GMT

The Qlikview applications can be scheduled to run after the generator app uisng the QMC. One of the trigger options is "After completion of another task".

-Rob