topic Reload time not refreshing when Reloaded with BAT File...! in QlikView

Reload time not refreshing when Reloaded with BAT File...!

avula_gk — Sat, 16 Nov 2024 20:32:11 GMT

Hi,

I tried to relaod the data with Bat file , in the script i have time captured in variable with vReload_Time=Now(),

the variable captures the data when reloaded in Qlikview front end. When i tried to load through bat file, the QVD files loads perfectly, but the variable doesn't capture the latest reload time.

Will be helpful if i get quick response.

Regards,

Ganesh

Re: Reload time not refreshing when Reloaded with BAT File...!

dplr-rn — Tue, 02 Jul 2019 20:23:34 GMT

change your code to now(1)

from help

"If you use the function in a load script, timer_mode=0 will result in the time of the last finished data load, while timer_mode=1 will give the time of the function call in the current data load."

You can also use reloadtime function

Re: Reload time not refreshing when Reloaded with BAT File...!

NZFei — Tue, 02 Jul 2019 22:56:07 GMT

I use the now() function in the script all the time and never had any issue.

Has the QlikView document reloaded and saved successfully?

When you said the variable doesn't capture the latest reload time, what does it show then?

How do you show the variable value? ='$(Variable)' ?

Re: Reload time not refreshing when Reloaded with BAT File...!

avula_gk — Wed, 03 Jul 2019 09:29:36 GMT

Hi,

Its been saved, the variable shows the last reload time which i ran through qlikview application.

Say first instance of Reload through qlikview application then $variable = 4.35 PM (when i reload on Qlikview application.)

2nd instance Reload on 5.00 Pm through bat file, after reload if i open the Qlikview application $variable should have 5.00Pm , but it shows first instance value i.e., 4.35PM

Regards,

Ganesh

Re: Reload time not refreshing when Reloaded with BAT File...!

marcus_sommer — Wed, 03 Jul 2019 14:29:21 GMT

Maybe it's an alternatively just to use reloadtime() within the UI instead of assigning now() to a variable during the load.

Usually I don't use a command line statement to update an application else vbs-batches and therefore I couldn't really say why the variable-value doesn't changed. A possible reason might be that the bat really refreshed the data without intializing the UI which meant that only the data of the qvw changed and everything else is untouched - which would be quite similar to the way how the qvb.exe worked. I never tested it - it's just a guessing.

What you could try is to set the variable per /v parameter within the command line - it might enforce a different behaviour.

Beside this you could write the value into a table and fetching the value from there.

- Marcus

Re: Reload time not refreshing when Reloaded with BAT File...!

avula_gk — Wed, 03 Jul 2019 15:17:08 GMT

Non of the things worked out. when i closed and reopened the QVW file then it automatically, refreshed the reload time in the variable.

Might be UI not gets refreshed when we reload thru bat file, i cant see a refresh file instead of reload, which will be helpful for my case.

Regards,

Ganesh