topic How to generate qvd automatically monthly.? in QlikView

How to generate qvd automatically monthly.?

Fri, 11 Feb 2011 09:48:14 GMT

Dear all,

I have a oracle server and a qv server. I wanna use ole db to get data from oracle server.

New data generate monthly. And I want to get qvd file after the new data comes out. How to do this automatically?

I have no idea about this. Could I use command line and bat file in windows os task scheduler? If yes, what is the command in qv.

Thanks

How to generate qvd automatically monthly.?

maneshkhottcpl — Fri, 11 Feb 2011 09:50:47 GMT

Hi,

One way to use the batch file to create a qvd. and schedule the batch file monthly once.

How to generate qvd automatically monthly.?

Fri, 11 Feb 2011 10:08:03 GMT

hi, How can I write this batch file? How can I use qv command in command line.

How to generate qvd automatically monthly.?

matt_crowther — Fri, 11 Feb 2011 10:34:38 GMT

In a .bat file (Inc the ") - write in Notepad and save as .bat:

"C:\Programs\Qlikview\Qv.exe" /r "C:\My Documents\MyFile.qvw"

The first part is the path to where your Qlikview .exe is located, the '/r' is the reload and save command and the final part is the path to the .qvw you wish to reload.

As an alternative if you're running server edition or reload manually everyday is to put an It...Else statement in the load script that looks to see if today() is equal to monthend(month(today())) and if so stores out the qvds.

Hope that helps,

Matt - Visual Analytics Ltd

How to generate qvd automatically monthly.?

suniljain — Fri, 11 Feb 2011 11:06:38 GMT

is there any updation in previous month's data in current month.

e.d : Sales Order,Purchase Order of previous month can be change in currewnt month.

so according you have to set the procedure.

for more information just search "append" in Qlikview help . you will get more details on ETL.

How to generate qvd automatically monthly.?

Fri, 11 Feb 2011 14:28:29 GMT

Hi Sunil,

There is no updating of previous month in current month.

How to generate qvd automatically monthly.?

Fri, 11 Feb 2011 14:42:56 GMT

Hi Matt,

I have almost understood, but there is still sth. need to be cleared. Could you please explain me how to use comand line of qv, or any referance documents avail from you? Is there any other parameters such as /r ? Thanks.


matt.crowther wrote:
In a .bat file (Inc the ") - write in Notepad and save as .bat:
"C:\Programs\Qlikview\Qv.exe" /r "C:\My Documents\MyFile.qvw"
The first part is the path to where your Qlikview .exe is located, the '/r' is the reload and save command and the final part is the path to the .qvw you wish to reload.
As an alternative if you're running server edition or reload manually everyday is to put an It...Else statement in the load script that looks to see if today() is equal to monthend(month(today())) and if so stores out the qvds.
Hope that helps,
Matt - Visual Analytics Ltd<div></div>