How to get previous two months data when u click on any date

[#1]

Hi All,

In qlikview i need previous two months data when i click on any date...

its means, if i click on Apr2010 its should give data of Feb2009

and if i click on May2010 its should give data of Mar2009

and if i click on Jun2010 its should give data of Apr2010... the date are as per financial year and month...

i hav used set analysis to get the above result, the code is working fine for all the month except for May2010,

its giving data of Mar2010 instead of giving Mar2009,can any one help me in this its very urgent...

Code:-

sum({$<[MTH_FIN YEAR] = {$(=only([MTH_FIN YEAR]) - $(=if(only(MTH_Fin_Month_No) = 1,1,0)))},MTH_Fin_Month = {$(=month(addmonths(MTH_MONTH_YEAR, -2)))}>} AMRT_AMT)/10000000

thanks...

Regards

Praveen

[deepakk]

Hi Praveen,

I hope this application helps you out.

[#3]

Hi Deepak,

Thanks....

but my synareio is different....

i have made some changes in ur application then it is not working....

jst check the application,i have chaged the year for month of Apr and May

so if i click on 201004 then its show data for 200902 and if i click on 201005 then its show data for 200903...

so how i will get it can u help me........

Test:
LOAD * INLINE [
Product, Date, Amt
A,01/01/2009,1000
A,01/02/2009,1500
A,01/02/2009,1300
A,01/03/2009,1200
A,01/03/2009,2000
A,01/03/2009,3000
A,01/04/2010,4000
A,01/04/2010,1700
A,01/05/2010,4000
A,01/05/2010,1700

];

thanks....

Regards

Praveen

[deepakk]

Try this application