Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Direct Discovery - Auto-Refresh How-To?

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.

Tags (2)
4 Replies
Not applicable

Re: Direct Discovery - Auto-Refresh How-To?

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

Not applicable

Re: Direct Discovery - Auto-Refresh How-To?

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.

Not applicable

Re: Direct Discovery - Auto-Refresh How-To?

What kind of data source did you use?

So you didn't use QlikView Server?

Not applicable

Re: Direct Discovery - Auto-Refresh How-To?

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

Sorry

Community Browser