Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Go to 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'
People get annoyed of always clicking that thing. A text field with reload time is less obtrusive.
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 =)