Selecting LAST MONTH

[#1]

i have some data  in my Qlikview

My filters are Years  and Months

2000 to  2015

and months   Jan to  December

Working Nicely:  When i select  year and Month together  for example:     year 2014 and month july   it will give me the data of  july 2014.

My Requirement     if i click  year  2014  or any previous years  (without selecting month)  it should give me the data of  last month (December)

and If i Select  2015  it should give me the  the data of  Last Month ( in my case May is my last Month)

Please write any set analysis code for me plz

thanks

[#2]

i have a very heavy database behind it

and there are some official information

so .. sorry i can't send

[Chanty4u]

try dis,

=Sum({$<Month={$(=Max(year)-1)}>}Sales)

hope dis helps

Thank you

Suresh

[#4]

thanks it works....