Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Which RangeSum() method is better

These two formulas give the same result:



* 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


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