topic Reloading data into Qlikview using a schedule in QlikView

Reloading data into Qlikview using a schedule

Anonymous — Thu, 07 Apr 2011 09:21:59 GMT

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?

Reloading data into Qlikview using a schedule

Thu, 07 Apr 2011 09:26:43 GMT

Hi ,

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

Reloading data into Qlikview using a schedule

Thu, 07 Apr 2011 09:32:40 GMT

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

Reloading data into Qlikview using a schedule

Thu, 07 Apr 2011 09:33:08 GMT

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

Reloading data into Qlikview using a schedule

Anonymous — Thu, 07 Apr 2011 09:43:15 GMT

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

Reloading data into Qlikview using a schedule

Anonymous — Thu, 07 Apr 2011 09:45:14 GMT

Thank you - just precisely what I was looking for!

Reloading data into Qlikview using a schedule

Anonymous — Thu, 07 Apr 2011 09:46:37 GMT

Thank you - just what I needed.

Reloading data into Qlikview using a schedule

colinh — Thu, 07 Apr 2011 09:48:44 GMT

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.

Re: Reloading data into Qlikview using a schedule

Fri, 22 Jun 2012 14:19:16 GMT

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?