topic Re: Direct Discovery - Auto-Refresh How-To? in QlikView

Direct Discovery - Auto-Refresh How-To?

Fri, 05 Jul 2013 12:30:34 GMT

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.

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

Fri, 05 Jul 2013 15:00:11 GMT

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

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

Fri, 05 Jul 2013 22:14:50 GMT

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.

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

Mon, 08 Jul 2013 06:14:30 GMT

What kind of data source did you use?

So you didn't use QlikView Server?

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

Mon, 08 Jul 2013 06:31:50 GMT

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

Sorry