topic Re: Monthwise Accumulation in QlikSense Pivot table in App Development

Monthwise Accumulation in QlikSense Pivot table

amruta_j — Sat, 16 Nov 2024 01:23:51 GMT

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?

Re: Monthwise Accumulation in QlikSense Pivot table

tresB — Thu, 24 Sep 2020 06:13:32 GMT

@amruta_j

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

Re: Monthwise Accumulation in QlikSense Pivot table

amruta_j — Thu, 24 Sep 2020 12:27:39 GMT

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

sum({1<[BalSheet.Period]={">=$(vMinBalSheet)<=$(=max([BalSheet.Period]))"}>}FCBAL)/1000

*** 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?