Rolling Months.

stevietm — Mon, 19 Mar 2012 09:13:22 GMT

Hi Everyone

I have a pivot, and I am working out months rolling. All works fine when I work out 3months, 6months and 12 months rolling, but when I try to work out 9months rolling I get no Values back at all. Does anyone maybe know why this is happening??

This is the expression I am using =sum(if(Inmonths (3,Time, SetDateYear (LatestMonth, max (total Year (Time))), 0,2), Value)) ...

Kind Regards

And thanks in Advance

topic Rolling Months. in QlikView

Rolling Months.