topic How do i get my Qlikview document to automatically reload? in QlikView

How do i get my Qlikview document to automatically reload?

hopkinsc — Mon, 07 Dec 2009 17:43:49 GMT

Hi, i have created a Document which uses a spreadsheet for its data, The spreadsheet is updated on a daily basis. At the moment, after i launch the Qlikview doc, i have to click relaunch to update the values from the spreadsheet. Can this be done automatically on launch of the document?

How do i get my Qlikview document to automatically reload?

Mon, 07 Dec 2009 17:56:12 GMT

create a macro

sub reload

ActiveDocument.Reload

end sub

and set it to run on open document

regards

Peter

How do i get my Qlikview document to automatically reload?

hopkinsc — Mon, 07 Dec 2009 18:13:47 GMT

Thanks very much Peter, that worked fine. I tried doing that earlier today but i was using the SELECTION command instead of ACTIVEDOCUMENT.

Thanks very much

How do i get my Qlikview document to automatically reload?

kji — Mon, 07 Dec 2009 19:26:05 GMT

You can also launch your application by using the /L parameter as in:

"C:\Program Files\Qlikview\qv.exe" /L C:\MyData.qvw