topic Time in on open Pop up? in QlikView

Time in on open Pop up?

Thu, 04 Nov 2010 06:48:56 GMT

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!

Time in on open Pop up?

Bjorn_Wedbratt — Thu, 04 Nov 2010 08:08:40 GMT

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'

Time in on open Pop up?

Thu, 04 Nov 2010 08:17:50 GMT

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

-Alex

Time in on open Pop up?

Thu, 04 Nov 2010 09:10:03 GMT

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 😃