Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

harleen_singh
Contributor 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
sujeetsingh
Honored Contributor III

Re: last 12 months excluding previous month

Not applicable

Re: last 12 months excluding previous month

check this out.

Re: Rolling 12 months flag in master calendar script?

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

Not applicable

Re: last 12 months 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!

MVP
MVP

Re: last 12 months excluding previous month

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

Re: Re: last 12 months excluding previous month

Hi Lavi,

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

Regards,

Vijay

Community Browser