topic Automating Qlickview jobs in QlikView

Automating Qlickview jobs

Wed, 10 Jul 2013 20:14:40 GMT

Hi,

I have a qlikview job which will generate a QVD file when I run it.

Using this qvd file I have a dashboard which gets updated.

I would like to see if there is a way I can schedule this to run every morning for me.

Thanks-

Re: Automating Qlickview jobs

jagan — Wed, 10 Jul 2013 20:23:21 GMT

Hi,

You can use Qlikview publisher to schedule the reload time, or else create a batch file and schedule it in windows scheduler the batch file should contain the following command

[ path ]Qv.exe[ { switch } documentfile ]

Ex:

C:\> QV.exe /r FileName.qvw

Hope this helps you.

Regards,

Jagan.

Re: Automating Qlickview jobs

Wed, 10 Jul 2013 23:17:36 GMT

Thank you,

Yes it helped me.

Now how would I schdule a task which is callig a qvd file and updating the dashboard view.

What would I have to put in the batch script ?

Also can I save that file with todays data variable ?

so I want to save that file as output_daily_date

where date = todays date.

Bsically my code is right now

Load

abc,

xyz

from test.qvd

and this result should reload the data from this qvd and save the file with the name I want with a data variable.

Re: Automating Qlickview jobs

rwunderlich — Thu, 11 Jul 2013 01:23:12 GMT

Do you have a Qlikview Server?

-Rob

Re: Automating Qlickview jobs

Thu, 11 Jul 2013 10:49:41 GMT

Yes I do have a server

Thanks

Sent from my iPhone

Re: Automating Qlickview jobs

kaushiknsolanki — Thu, 11 Jul 2013 10:57:02 GMT

Hi Raj,

I believe you have Two QlikView Application.

One to generate the QVD and another QlikView Dashboard.

If yes then you need to schedule both the application one after another.

Regards,

Kaushik Solanki