Auto Reload of Data

[#1]

I am using Qlikview 9.0 SR5 Desktop and want to perform incremental reloads of the data to create a monitoring-type application. All the triggers i have tried to use to automatically run a macro to perform the reload do not fire. I only seem to be able to get the macro to fire when i perform manual changes (such as changing a variable). If it change the variable value in a macro or action it does not trigger the macro.

I am trying to achieve this using Qlikview Desktop only.

Any help would be greatly appreciated.

Cheers, Semir.

[#2]

Hi Semir,

There are lots of posts suggesting that a bat file can be ran which reloads the data, but it doesn't refresh the data within the open document.

So to get around that, I created a bat file which is scheduled to run every 5 minutes, using Windows Scheduler. The bat file closes the Qlikview application, then reloads the data and finally reopens the Qlikview document. The bat file is as follows:

TaskKill /F /IM QV.exe

"C:\Program Files\QlikView\QV.exe" /r "Path to your QlikView document"

Start "QlikView" /MAX "Path to your QlikView document"

Hope that helps

Dave