Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
i have a very heavy database behind it
and there are some official information
so .. sorry i can't send
try dis,
=Sum({$<Month={$(=Max(year)-1)}>}Sales)
hope dis helps
Thank you
Suresh
thanks it works....