Discussion Board for collaboration on QlikView Scripting.
I have a little QlikView application, which just directly loads one table from my database.
Tab1:DIRECT (Stale After 20 seconds) SelectCOLUMN1,COLUMN2From TABLE;
DIRECT (Stale After 20 seconds) Select
Now I want the program to automatically refresh this data, without me pressing the reload button, after a couple of seconds or minutes.
I have seen this before, but there was no explanation how to do that.
Does anyone knows how I can achieve this?
Thanks in advance.
You could use the qlikview server scheduler, to reload the document every couple of minutes/seconds. Or you could use the windows scheduler and reload your document via a batch file.
hope this helps.
As I've tested the feature (locally on pc), the data will be actually refreshed after the time set in the "stale" statement, without having to reload.
I added a button with a "restore object" action to make the changes appear in the chart.
Any other input from someone who tested that, will be surely useful.
Hope this helps anyways.
What kind of data source did you use?
So you didn't use QlikView Server?
I wanted to use the "STALE" statement to refresh the document, so this might work well, but it's not what I want.