Range functions will replace the following Chart General Numeric Functions: numsum, numavg, numcount, nummin and nummax, which should now be regarded as obsolete.
rangesum(expr1 [ , expr2, ... exprN ])
Returns the sum of a range of 1 to N arguments. As opposed to the + operator, rangesum will treat all non-numeric values as 0.
The argument expressions of this function may contain Chart Inter Record Functions with a third optional parameter, which in themselves return a range of values.
Examples:
| rangesum (1,2,4) | returns 7 |
| rangesum (1,'xyz') | returns 1 |
| rangesum (null( )) | returns 0 |
| rangesum (above(count(x),-1,3)) | returns the sum of the three results of the count(x) function evaluated on the row below the current row, the current row and the row above the current row. |
rangeavg(expr1 [ , expr2, ... exprN ])
Returns the average of a range of 1 to N arguments. If no numeric value is found, NULL is returned.
The argument expressions of this function may contain Chart Inter Record Functions with a third optional parameter, which in themselves return a range of values.
Examples:
| rangeavg (1,2,4) | returns 2.33333333 |
| rangeavg (1,'xyz') | returns 1 |
| rangeavg (null( ), 'abc') | returns NULL |
| rangeavg (above(count(x),0,3)) | returns a sliding average of the result of the inner count(x) expression calculated on the current row and two rows above the current row. |
Check out Help in Qlikview for more information
