Direct Discovery - Auto-Refresh How-To?

[#1]

Hi,

I have a little QlikView application, which just directly loads one table from my database.

Tab1:
DIRECT (Stale After 20 seconds) Select
COLUMN1,
COLUMN2
From TABLE;

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.

[#2]

Hey,

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.

gr.

Frank

[#3]

Hi,

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.

[#4]

What kind of data source did you use?

So you didn't use QlikView Server?

[#5]

I wanted to use the "STALE" statement to refresh the document, so this might work well, but it's not what I want.

Sorry