Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
avastani
Partner - Creator III
Partner - Creator III

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!

0 Replies