topic Which RangeSum() method is better in QlikView

Which RangeSum() method is better

Wed, 10 Dec 2014 09:04:10 GMT

These two formulas give the same result:

=RangeSum(Above(Sum(Sales),0,RowNo())) 
=RangeSum(Above(TotalSales),Sum(Sales))

* TotalSales is a label of expression within this formula

So the question is which method is better and why?

jagan — Wed, 10 Dec 2014 10:04:33 GMT

Hi,

Check explanation below

=RangeSum(Above(Sum(Sales),0,RowNo())) - If you are accumulating from top row to current row this method is used
=RangeSum(Above(TotalSales),Sum(Sales)) - If you are summing up above row and current row sales

Regards,

Jagan.