topic Re: Show Last Reload and Next Reload in QlikView

Show Last Reload and Next Reload

Wed, 04 Mar 2015 16:42:48 GMT

------------------------------

='Data Updated on: '
&vLastReload

---------------------------------

The above statement tells me when the document was last reloaded. How do i also show when the next reload will be or can it not do that?

So last reload was x and the next reload is y.

Regards

Tyrone

Re: Show Last Reload and Next Reload

Gysbert_Wassenaar — Thu, 05 Mar 2015 12:53:48 GMT

Qlikview documents are usually not clairvoyant so they won't know when they will be reloaded again. But if you know this date/time in advance you could create another variable and give it this value. Perhaps you reload your document on an hourly basis:

// Start of script

LET vNextReloadTime = timestamp(ReloadTime() + 1/24,'DD-MM-YYYY hh:mm:ss');

...rest of the script...

// End of script

Re: Show Last Reload and Next Reload

oknotsen — Thu, 05 Mar 2015 14:02:00 GMT

Instead of using a variable for your last reload date+time, you can also use a function for that:

ReloadTime()

Since it is hard to know when the next reload will be, I would agree with the previous replier about guessing the "next reload date+time".

Re: Show Last Reload and Next Reload

Thu, 05 Mar 2015 15:40:44 GMT

Thanks. how do i add that into my expression

='Data Updated on: '
&

vLastReload

Next reload will be:

LET vNextReloadTime = timestamp(ReloadTime() + 1/24,'DD-MM-YYYY hh:mm:ss');

Regards

Tyrone

Re: Show Last Reload and Next Reload

Gysbert_Wassenaar — Thu, 05 Mar 2015 17:44:00 GMT

The LET statement is part of the script. When you reload the document the variable vNextReloadTime will be given its value. You can use the variable then in expressions in the front end:

='Data last updated on ' & vLastReload & chr(10) & chr(10) & 'Next reload will be at ' & vNextReloadTime

Re: Show Last Reload and Next Reload

rwunderlich — Thu, 05 Mar 2015 19:08:33 GMT

While not showing it in Document itself, if you click "View Details" in Access Point, you can see the scheduled time of the next reload.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Show Last Reload and Next Reload

martijn — Wed, 06 May 2015 10:02:49 GMT

Hi Rob,

Maybe a stupid question, but where can I find this option? I have serveral QV versions, but I'm not able to show the Next Update.

Regards,

Martijn

Re: Show Last Reload and Next Reload

rwunderlich — Thu, 07 May 2015 23:36:28 GMT

Hi Martijn,

The "View Details" option should be available is the Access Point document list if you are running QV 11. Do you see the option?

-Rob

Re: Show Last Reload and Next Reload

martijn — Fri, 08 May 2015 05:48:24 GMT

That's the thing. I don't see that option:

I’ve tried different QV 11 environments, but I don’t see it…..

Re: Show Last Reload and Next Reload

martijn — Fri, 08 May 2015 09:46:33 GMT

I’ve done some additional research. Most off our dashboards are refreshed based on a successful event from another task. That is why it isn’t shown.

When a new schedule is made, the next reload time will be shown after the first reload. And the most important part: you have to have a publisher license

Re: Show Last Reload and Next Reload

Anonymous — Mon, 06 Nov 2017 19:31:18 GMT

Hi Gysbert

In qlikview server we can find the task XML file which has the recurrence information. We can use that file as input and add the recurrance time to last reload time to get next reload time.

Do you think it is the right way of doing it?

Thanks

Venkata S

Re: Show Last Reload and Next Reload

Gysbert_Wassenaar — Tue, 07 Nov 2017 08:06:31 GMT

Should work for any tasks that have a time based schedule. If the task depends on another event it will be more complicated.