topic Re: Dynamically creating month labels from Sysdate in QlikView

Dynamically creating month labels from Sysdate

Tue, 03 Sep 2013 15:57:55 GMT

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,

Re: Dynamically creating month labels from Sysdate

stigchel — Tue, 03 Sep 2013 16:13:28 GMT

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

Re: Dynamically creating month labels from Sysdate

Wed, 04 Sep 2013 18:20:59 GMT

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

Re: Dynamically creating month labels from Sysdate

Anonymous — Wed, 04 Sep 2013 18:45:49 GMT

This:

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

Re: Dynamically creating month labels from Sysdate

Wed, 04 Sep 2013 18:57:46 GMT

Thank you Michael, this works

Re: Dynamically creating month labels from Sysdate

Anonymous — Wed, 04 Sep 2013 19:08:25 GMT

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().