topic ReloadTime() not getting set? in QlikView

ReloadTime() not getting set?

Fri, 12 Feb 2010 19:39:53 GMT

Greetings.

I've had complaints about a QVW I have that the ReloadTime() keeps displaying the time *I* last ran the load (before I distributed the QVWs). The QVWs get delivered pretty much empty, and then the user has them loaded in an overnight process that is called with the OCX. Other system variables seem to be fine, but even though the data is clearly updated, the ReloadTime() remains set to the last time I had done the reload while it was under development.

Heard of this? I can just change it to store the date in my own variable at the end of the run - I was just keen on using system variables where I could.

Thanks.

ReloadTime() not getting set?

pdumas — Fri, 12 Feb 2010 21:51:50 GMT

Hi,

I already faced this problem because my code was

Set MyVariable=releadtime();

I changed to

Let MyVariable=releadtime();

and everything recovered

Pierre.

ReloadTime() not getting set?

rwunderlich — Sat, 13 Feb 2010 10:37:00 GMT

ReloadTime() returns the end of the *last completed* script execution. It is not reset until the script end. It's not generally useful in the script to reflect anything about the current script run.

If used directl in the UI, it does show the correct end time. If used in the script, it reflects the end of the *previous* script run.

Instead of using ReloadTime(), I usually start all my scripts with
LET SCRIPT_START = now(1);

And end them with:
LET LOAD_DURATION = now(1) - SCRIPT_START;

-Rob

ReloadTime() not getting set?

pdumas — Sat, 13 Feb 2010 11:52:12 GMT

Hi Rob,

I checked my script and I had replaced the ReloadTime function with

Let vScriptReload=today();

Thanks for trick on how to monitor reload duration

Pierre.

ReloadTime() not getting set?

Mon, 15 Feb 2010 16:46:29 GMT

Its not in the script that I use it - its in a text box on a screen. So I was hoping it would be set to the last completed script execution. That was the whole point - so the user could see if the data in the QVW was up-to-date. The problem is, the load has been successfully run, multiple times, and the date on the screen is still from two weeks ago, when I last ran it on my pc.

I realize the easy fix is to just stuff today() into a variable, which is what I will do. I had wondered if I was using the system variable incorrectly (and it sounds like I'm not -- must be another fun "feature" with the OCX).

Thanks.

ReloadTime() not getting set?

hopkinsc — Fri, 04 Feb 2011 13:40:42 GMT

Hi Rob,

How would i then get this displayed in my application?

Chris

ReloadTime() not getting set?

suniljain — Fri, 04 Feb 2011 13:46:37 GMT

Write following code in Text Object

=Reloadtime()

ReloadTime() not getting set?

rwunderlich — Fri, 04 Feb 2011 19:46:38 GMT

Chris,

Assume in your script you have:

LET vScriptStart = now(1);

LET vLoadDuration = now(1) - vScriptStart;

In your app create a text box with:

='Last Reload: ' & vScriptStart & '
Load Duration: ' & interval(vLoadDuration, 'hh:mm:ss')

-Rob

ReloadTime() not getting set?

Anonymous — Wed, 12 Oct 2011 16:17:18 GMT

Hello,

I am usign ReloadTime() but I want to separate the date and the time and the date like the exaples below that I have in two text boxes:

='Hoy es ' & Date(today(),'MMMM') & ' ' & Date(today(),'DD') & ' de ' & Date(today(),'YYYY')

='Son las ' & time(now(),'hh:mm tt')

Now I wat to do the same with ReloadTime(), is it possible?

ReloadTime() not getting set?

rwunderlich — Thu, 13 Oct 2011 18:36:30 GMT

I don't think you need to break it into three pieces. You can just do:

='Hoy es ' & Date(today(),'MMMM DD YYYY'')

or ='Hoy es ' & Date(ReloadTime(),'MMMM DD YYYY'')

time(ReloadTime. 'hh:mm tt')

-Rob

Re: ReloadTime() not getting set?

Anonymous — Thu, 11 Oct 2012 12:58:26 GMT

Rob Wunderlich wrote:
If used in the script, it reflects the end of the *previous* script run.

This is exactly how I'm using in the script in one of my applications:

LET PreviousReload = ReloadTime();

It was working as expected, but recently I upgarded to QV11 SR2, and it changed. In SR2, ReloadTime() returns the time of the script execution start, and keeps it during the reload process. After the reload is finished, it returns the end of the reload process.

Have to use something else to get the previuos reload time...

Regards,

Michael

Re: ReloadTime() not getting set?

rwunderlich — Thu, 11 Oct 2012 15:37:58 GMT

Michael,

It looks like SR2 changed the interpretation of now(0) as well! I think both the ReloadTime() and now(0) change are bugs. The Help for now(0) says:

"0 Time at previously finished reload (not currently ongoing reload)"

and for ReloadTime():

"Returns a timestamp for when the script last finished reexecuting."

There have been changes in behavior of now() in the past, and they have caused me rework Because of that, I don't rely on any of the time functions to establish a point in time except for now(1), the current time. I use now(1) to set my own variables.

-Rob

Re: ReloadTime() not getting set?

Anonymous — Thu, 11 Oct 2012 16:34:08 GMT

Rob,

I'm going to report it to QlikTech as a bug.

As for my application, I'm now getting the previous reload time from the timestamp of a QVD file which is modified later in the process.

Regards,

Michael

Re: ReloadTime() not getting set?

amien — Sun, 03 Mar 2013 09:39:35 GMT

Did you get any response from QlikTech?

Re: ReloadTime() not getting set?

Anonymous — Mon, 04 Mar 2013 13:03:31 GMT

Yes, this is from Oct 15, 2012:

"... Your recent support case as described below has now been confirmed by our Issue Analysis team as a bug, ID 51903.

Due to uncertainties regarding potential related problems and program priorities we cannot guarantee a fix date at this time ..."

I didn't check if it was fixed later.

Regards,

Michael