topic Re: What does function ReloadTime() evaluate? in QlikView

What does function ReloadTime() evaluate?

Wed, 27 Aug 2014 12:33:05 GMT

Hallo,

one of our qvw files has got the following code at the beginning of the script:

Let sReloadTime=ReloadTime( );

Within, there is a textfield containing following code for the text property:

=' Last Reload was at ' & sReloadTime.

QlikView Server reloads this file every morning at 5:00 a.m.. The textfield does not show the current day, when you open it. It shows the last day 5 a.m.

I checked the server time, but it is correct.

So when is ReloadTime() evaluated. Does it really know at the beginning of the reload, that last reload was day before? Or should we just call the function within the textfiled text property?

We use QV Version 11..

Re: What does function ReloadTime() evaluate?

Anonymous — Wed, 27 Aug 2014 13:23:26 GMT

The function shows the reload time of the last completed reload, which is the day before. If you want to show the reload time in a text box, use it right there, not in the script:

='Last Reload was at: ' & ReloadTime())

You may want to use timestamp function around the reload time to format it nicely.

Re: What does function ReloadTime() evaluate?

ashfaq_haseeb — Wed, 27 Aug 2014 13:27:06 GMT

Hi,

It displays the time your document was reloaded last time.

Regards

ASHFAQ

Re: What does function ReloadTime() evaluate?

Thu, 28 Aug 2014 12:13:59 GMT

Michael,

you were absolutely right and I had the same idea but wanted to be sure, that others have the same idea. A bit annoying is, that ReloadTime() used in a script is returning a value anyway, because while running the script the script itself does not know when it will be finished.

The documentation of ReloadTime() says, that it returns the day and time of the end of the last Reload. So how could it return a value anyway. Or in other words: What is it returning in the first reload?

On the other side, it might be helpful to get the time when the reload was last successful.

Re: What does function ReloadTime() evaluate?

rustyfishbones — Thu, 28 Aug 2014 12:16:54 GMT

ReloadTime( )

Returns a timestamp for when the script last finished reexecuting.

Re: What does function ReloadTime() evaluate?

Anonymous — Thu, 28 Aug 2014 12:24:38 GMT

I think that Ashfaq Mohammed and Alan Farrell answered your follow-up questions