Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I Just want to show the sum of last twelve months excluding Previous month using Set analysis
So if today is dec 2013, i want sum from nov 2012......... to oct 2013.
thanks
Lavi
check this out.
Re: Rolling 12 months flag in master calendar script?
put' -2 ' when ever u r excluding previous month...
Hi,
These might be of help:
http://community.qlik.com/message/237995
http://community.qlik.com/message/361878
You might need to tweak the formula a bit to suit your requirements, as they are for last 12 months straight and not excluding the previous month.
Hope this helps!
May be something like :
=sum({<Date = {">=$(=MonthStart(Max(Date), -11))<=$(=MonthEnd(Max(Date), -2))"},Year=,Month=>}Amount)
Note: parameters ,-11/-2 may varry based on your requirement. If any doubt, please share your sample app.
Hi Lavi,
I have did something with variables, Please try it might be helpful for you.Create Month ID in Your Calendar.
Regards,
Vijay