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.
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"
