topic Range sum is not working properly in QlikView

Range sum is not working properly

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

Hi Team,

I am trying to calculate running total by using rangesum function
=Aggr(RangeSum(Above(TOTAL Sum([ABS Error EA (Shipment)]), 0,RowNo())), [Product Level Value])

But unfornately its not returning the correct values.

Please suggest the correct solution.

Thanks in Advance

Re: Range sum is not working properly

jyothish8807 — Tue, 26 Mar 2019 08:59:51 GMT

Hi,

Try this if it works:

RangeSum(Above(TOTAL Aggr(Sum([ABS Error EA (Shipment)]),[Product Level Value]), 0,RowNo()))

or just this:

RangeSum(Above(TOTAL Sum([ABS Error EA (Shipment)]), 0,RowNo()))

Re: Range sum is not working properly

ajaymehtaece — Tue, 26 Mar 2019 09:30:24 GMT

Thanks for reply Jyothi,
But the formula suggested by you is not working for me.

Re: Range sum is not working properly

jyothish8807 — Tue, 26 Mar 2019 09:47:49 GMT

Will it be possible to share a sample data?