Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harleen_singh
Creator III
Creator III

last 12 months excluding previous month

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

5 Replies
Not applicable

check this out.

Re: Rolling 12 months flag in master calendar script?

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

Not applicable

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!

tresesco
MVP
MVP

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.

Not applicable

Hi Lavi,

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

Regards,

Vijay