Discussion board where members can get started with QlikView.
I have requirement to show Current Month,Current Quarter, Last Month,Last Quarter data in Desiner Part. Can one help me on this?
Current Month: =Month(Today())
Current Quarter: =Year(Today())&'Q'&ceil(Month(Today())/3)
Last Month: =Month(monthstart(Today(),-1))
Last Quarter: =Year(monthstart(Today(),-1))&'Q'&ceil(Month(monthstart(Today(),-1))/3)
Thanks for your reply.
My requriement has been changed little again. Actually I have a data only 2010 and 2011.
My requirement is 01-May-2011 need to show as Current Month
lly 01-APR-2011 need to show as Last Month
Current Quarter 01/04/2011 - 30/06/2011
Previous Quarter 01/01/2011 - 31/03/2011
Try like this in script
AddMonths(AddYears(DateFieldName, 3), 2) AS NewDate
Now use the new field for your analysis.
Try something like this
Instead of Today() use Max(Date) like
Current month : month(max(Date))