Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
avula_gk
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
avula_gk
Partner
Partner
Author

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

View solution in original post

5 Replies
dilipranjith
Partner
Partner

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

xufei123
Partner
Partner

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

avula_gk
Partner
Partner
Author

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

marcus_sommer
MVP & Luminary
MVP & Luminary

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

avula_gk
Partner
Partner
Author

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

View solution in original post