Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

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

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

 

Labels (3)
1 Solution

Accepted Solutions
Partner
Partner

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

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

5 Replies
Partner
Partner

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

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

Partner
Partner

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

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)' ?

Partner
Partner

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

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

MVP & Luminary
MVP & Luminary

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

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

Partner
Partner

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

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