Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Monthwise Accumulation in QlikSense Pivot table

Hi All, need your help in calculating accumulated month wise sum in Balance Sheet pivot.


Attached is the current table which is having correct data with below formula:

RangeSum(before(Total SUM(FCBAL), 0, ColumnNo(TOTAL)))

Now my requirement is user just want to see last 3 years figures, which is 2017,2018,2019.

If I filter Year field, accumulation for 2017 is not happening. So for 2017 column, data should be accumulated from 2011-2017 and so on. I need to do it in front end.

Any solution on this please?


Labels (2)
2 Replies


May be like:       RangeSum(before(Total SUM(FCBAL), 0, 3))

Partner - Contributor III
Partner - Contributor III

Now I'm able to get correct numbers for 3 years with set analysis in straight table:


*** vMinBalSheet=min(Total{1} [BalSheet.Period])

But now after applying filter, numbers are not right. I don't want to bypass the field as user is having option to choose monthyear.

Any idea?