Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

avastani
Contributor II

Rolling Average in YTD, MTD, QTD scenario fails

I am using the expression

RANGESUM( Before( sum({<YTDFlag={1}>}SalesAmount), 0, 3) )

My table looks like

Department YTD PYTD

d1 xxxx xxxx

d2 xxxx xxxx

The pivot table shows only nulls because the before() function fails to retrieve results which makes sense. Is there anyway around it? I tried above and that didn't do anything either.

Is there any other inter-record function that could make it work in the expression? Thanks for your help folks!

Community Browser