last 12 months excluding previous month - Qlik Community

harleen_singh · ‎2013-12-02

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

sujeetsingh · ‎2013-12-02

Report Inappropriate Content · ‎2013-12-02

check this out.

put' -2 ' when ever u r excluding previous month...

Report Inappropriate Content · ‎2013-12-02

Hi,

These might be of help:

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!

tresesco · ‎2013-12-02

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.

Report Inappropriate Content · ‎2013-12-02

Hi Lavi,

I have did something with variables, Please try it might be helpful for you.Create Month ID in Your Calendar.

Regards,

Vijay