Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Which RangeSum() method is better

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?

Tags (1)
1 Reply
MVP & Luminary
MVP & Luminary

Re: Which RangeSum() method is better

Hi,

Check explanation below

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

Regards,

Jagan.