topic Re: ReloadTime() in script in QlikView

ReloadTime() in script

shayraber — Tue, 26 Dec 2017 15:04:17 GMT

hi,

why when I'm writing in script:

table_temp:

LOAD *,

RELOADTIME() AS reload_time,

....;

and when i write in a text object: "=ReloadTime()"

i get different results?

p.s.

reload takes ~15 sec

value diff is ~4min

Re: ReloadTime() in script

Anil_Babu_Samineni — Tue, 26 Dec 2017 15:07:08 GMT

Yes, You should Reload() now to get equal. And, In text object i believe we will get 10 seconds delay.. Because, QIX reloads script first and then UI

Re: ReloadTime() in script

shayraber — Tue, 26 Dec 2017 15:13:50 GMT

Anil,

thanks for the quick reply

but i don't understand

the whole process takes about 10-15 seconds (reload script and UI)

when i'm writing in script "Reload() as ...;

what value is assigned to that field? reloadtime of what? the reload time of the script execution, no?

and also,

once the document was reloaded, saved and reopened - what value is being assigned to the textbox when i write inside "=reloadtime()"?

Re: ReloadTime() in script

sunny_talwar — Tue, 26 Dec 2017 15:20:02 GMT

I am not sure, but could be that the ReloadTime() in the script is the ReloadTime() from the last run.... checking this theory now....

Re: ReloadTime() in script

shayraber — Tue, 26 Dec 2017 15:22:00 GMT

you are right!

thanks!

just checked it now

Re: ReloadTime() in script

sunny_talwar — Tue, 26 Dec 2017 15:23:35 GMT

I think that is what it is....

Reload1

Reload2

See how Reload2's reload_time = Reload1's ReloadTime(). I think the reason is because the true reload time is captured at the end of the script. Since you are still running the script while you use ReloadTime() in the script, the ReloadTime() is used from the last reload.

Does this make sense?

Re: ReloadTime() in script

shayraber — Tue, 26 Dec 2017 15:27:30 GMT

the answer is what you (Sunny) wrote.

-> when written in script - RelodTime() returns the timestamp of last reload.

the solution is what Anil wrote

-> the way to handle this is to use Now() function in script in order to have pre-calculated field based on the script execution time