Dynamically creating month labels from Sysdate - Qlik Community

Report Inappropriate Content · ‎2013-09-03

How can we create a last 3 months label (For ex: As of now it should June 2013/July 2013/August 2013) from sysdate?

Please let me know about the functions.

Thank you,

stigchel · ‎2013-09-03

Rob Wunderlich has created a good application to handle date ranges, where he creates a simple calendar and creates date ranges which you can modify according to what you want.

look on RobWunderlich.com

Report Inappropriate Content · ‎2013-09-04

I just need a simple function to calculate month last month label from sysdate, thats not available in the mentioned QVW.

Anonymous · ‎2013-09-04

This:

=date(addmonths(today(),-3),'MMMM YYYY') &'/' &date(addmonths(today(),-2),'MMMM YYYY') &'/' & date(addmonths(today(),-1),'MMMM YYYY')

Report Inappropriate Content · ‎2013-09-04

Thank you Michael, this works

Anonymous · ‎2013-09-04

Sure it does...

An advice: You asked for sysdate, which is retrieved here by the today() function. In practice, especially if the application is not reloaded every day, the reload time is more relevent than the curent date. If this is the case, just replace today() with the ReloadTime().