Time in on open Pop up?

[#1]

Hi,

Is this possible? I was wondering if i can show in a pop up message on open of the document how many hours and or minutes has passed since the last reload of the file.

Hope someone can help.

Thanks!

[Bjorn_Wedbratt · Accepted solution]

You could use an alert (Tools-> Alerts..) and have it trigger on Open with "Show popup" selected.
In the message box for the alert you could use an expression similar to:

=' This file last reloaded ' & ReloadTime() & CHR(10) &
 hour(Now()-ReloadTime()) & 'hour(s) and' & CHR(10) &
Minute(Now()-ReloadTime()) & 'minute(s) ago'

[#3]

People get annoyed of always clicking that thing. A text field with reload time is less obtrusive.

-Alex

[#4]

Hi Alex,

well in my case, people here often complain about their data not being feed into qlikview without looking at the reload time so i wana show it in their screen when they open so they would stop complaining 😃