Discussion Board for collaboration on QlikView Publisher.
I am new to qlikview and have developed some reports on qlikview, which gets data from qvds, QVDs in turn get the data from SQL server database.
now I want to schedule the QVDs to refresh on a certain time daily or may be twice a day and also need to refresh the qlikview reports to get the latest data from the database.
Please let me know that how to automate this process, as of now I do it manually.
Thanks in advance
This sounds like a job for QlikView Server (+ Publisher)!
Create a task for the QVW file which create the QVD in QEMC
Ok might be a silly question but then how the reports will be refreshed or scheduled to run on Qlikview server??
you should have to make batch file for that.or using reload time functionality the reports will be refreshed
I searched for something similar. I need all my QVDs to be refreshed automatically at 7:30 am and at noon on working days. Any help is appreciated.
Thanks in advance.
Hi Keshav Pandya,
In Qlikview Publisher you have an option in document properties to schedule your qvd's as you wish.
Go to Settings->Document Properties->Scheduler...There you can define the start and end timings to refresh your qvds and for specific days as per your requirement .
With QlikView server you can set a reload schedule to reload your QVD generator at 0730 and repeat say every 4 or 6 hours or another interval.
Then you can schedule your application QVW to reload on successful completion of the QVD generator reload.
Please take a text file and type the below code and save as Test.bat format.
"C:\Program Files\QlikView\qv.exe" /r "E:\Test.qvw"
Now schedule the above batch file in Windows Task Scheduler in your desktop.
This will help You.