topic Re: Showing Dashboard Refresh Date in QlikView

Showing Dashboard Refresh Date

Wed, 22 Jan 2014 22:15:07 GMT

Hi,

I wanted to show the last update date andnext update date in my Qlikview dashboard. My data is in following format:

To show last update, am using minstring function and getting 2013-Q4, which is correct.

How can I show next update , which would be "2014-Q1" and I want to show the month of Feb also in a text box?

LOAD

*Inline

[
Quarter, Month
2013-Q4,Feb
2014-Q1,May
2014-Q2,Aug
2014-Q3,Nov
2014-Q4,Feb
]

;

Help would be appreciated.

Re: Showing Dashboard Refresh Date

Wed, 22 Jan 2014 22:31:44 GMT

Hey Simky,

I am not sure why you need a Inline table for that. You can use the function Reloadtime() to calculate when the doc was last reloaded. And if you want to inform the users when the next reload will happen you can just add +'number of days'.

In this example i used 20 days(mostly it will be reloaded everyday).

Hope it helps

Thanks

Re: Showing Dashboard Refresh Date

rustyfishbones — Wed, 22 Jan 2014 22:44:53 GMT

Hi,

You can use RELOADTIME()

for the Current Reload to get the Year and Qtr you can say

YEAR(RELOADTIME()) &' -Q' & CEIL(month(RELOADTIME())/3)

I hope that helps

Re: Showing Dashboard Refresh Date

ngulliver — Thu, 23 Jan 2014 09:38:56 GMT

Hi, Simky.

I tend to use let vLastLoadStart = now() at the start of my script and then put let vLastLoadEnd = now() at the end of my script. I can then put on the first tab of my app a text box containing:

=’Last load date: ‘ & date(vLastLoadStart, ‘DD MMM YYYY hh:mm:ss’) &

‘ Last load duration: ‘ & date(vLastLoadEnd – vLastLoadStart, ‘hh:mm:ss’)

Regards,

Neil

Re: Showing Dashboard Refresh Date

mjmastro — Mon, 11 Mar 2024 15:04:43 GMT

Neil, thanks for the tip. It's a good one. Best ...