Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
AJ
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
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
Neil, thanks for the tip. It's a good one. Best ...