topic Re: Range sum is not working properly in QlikView

Range sum is not working properly

ajaymehtaece — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to calculate running sum in pivot table using formula
RangeSum (above(TOTAL Sum([Actual Qty]),0,RowNo()))/RangeSum (above(TOTAL Sum([Forecast Lag0]),0,RowNo()))

But this formula is not working when i am showing my table horizontally (first tabular chart).

However its working fine for vertical pivot table (second table).

kindly guide me why this is happening and what is the solution to bring running total in first chart.

Re: Range sum is not working properly

tresB — Wed, 26 Dec 2018 08:26:15 GMT

For horizontal calculation to work, replace all above() with before()

Re: Range sum is not working properly

tresB — Wed, 26 Dec 2018 09:15:29 GMT

And yes, rowno() should be replaced with columnNo(). Therefore,

replace:

Above() with Before()

RowNo() with ColumnNo()

Re: Range sum is not working properly

ajaymehtaece — Wed, 26 Dec 2018 09:20:26 GMT

Thanks Tresesco

Solution provided by is working fine for me.Thanks A Lot