topic Problem with comparison with Rolling current year Vs previous Year in QlikView

Problem with comparison with Rolling current year Vs previous Year

Tue, 16 Jul 2013 05:18:21 GMT

Please help me for this I tried to a lot for this but still I am in trouble to find the average of Rolling last 18 months data. Because when we fetch the data for current year rolling 18 months data it works fine and when I find separately previous year data then also it gives correct output but when I try to compare between them it gives wrong output. Because the current Year rolling month July 2012 matched by previous year July.

Re: Problem with comparison with Rolling current year Vs previous Year

Tue, 16 Jul 2013 05:42:48 GMT

SET vMaxYear=MAX(Year)

Sum

({<Year={$(vMaxYear)},Month={"$(=Max({<Year={$(vMaxYear)}>}Month))"}>} Value) //Currentyear currentMonth

Sum

({<Year={$(=Max(Year(Year))-1)},Month={"$(=Max({<Year={$(vMaxYear)}>}Month))"}>} Value) //PreviousYear CurrentMonth

Hope it will help u

Re: Problem with comparison with Rolling current year Vs previous Year

Tue, 16 Jul 2013 08:00:05 GMT

Hi Bika

Thanks for ur Reply but Bika It is not exactly that I want. Bika I want to display only 18 Rolling months difference for example current year starts from July 2013 to Feb 2012 and Previous Year starts from July 2012 to Feb 2011.