Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaymehtaece
Contributor
Contributor

Range sum is not working properly

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

 

Rangesum.png

3 Replies
jyothish8807
Master II
Master II

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()))

Best Regards,
KC
ajaymehtaece
Contributor
Contributor
Author

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

Will it be possible to share a sample data?

Best Regards,
KC