Reloading data into Qlikview using a schedule

[Anonymous]

any ideas please how to set a Qlikview document to reload its data at a set time each day without manually opening the document and clicking on Reload?

[#2]

Hi ,

You can schedule it through the publisher or using macros and windows task scheduler

[#3 · Accepted solution]

Using windows scheduler you just need to create a .bat file containing:

CALL "C:\PROGRAM FILES\QLIKVIEW\QV.EXE" /R "C:\document path\document.QVW"

Regards,

Gordon

[#4]

Hi,

You can do this using windows scheduler also

1) just create a batch file having following command

"C:\Program Files\Qlikview\QV.exe" /r "D:\Upendra\test Data 5Apr.qvw"

This command will open the QV file, reload it, save it and close it automatically

2) create a scheduler and add that batch file to that scheduler( keep that scheduler setting runs daily at specific time)

Thanks & Regards

[Anonymous]

Thank you for your reply...I looked through the Automation Interface Reference guide but couldn't find a straight forward solution using macros.

[Anonymous]

Thank you - just precisely what I was looking for!

[Anonymous]

Thank you - just what I needed.

[colinh]

If you have QlikView Server 9 or later then open the Management Console, select User Documents, choose your document and select the Reload option on the right. This will allow you to set reload options for the document.

If you don't have Server then use the batch file methods above.

[#9]

One additional question on the subject... We have scheduled a reload of a document to occur every five minutes, but we only want this to occur within a 12 hour window during the day.  Does anyone know how we would go about doing this?