Discussion Board for collaboration related to QlikView App Development.
Hi all , Can Any1 explain the use of range function with an example
please close your open threads if you are satisfied or feel free to ask questions.
Pasted from Help:
RangeSum() returns the sum of a range of values.All non-numeric values are treated as 0, unlike the + operator.
Return data type: numeric
The arguments of this function may contain inter-record functions which in themselves return a list of values.
|first_expr||The expression or field containing the data to be measured.|
|Expression||Optional expressions or fields containing the range of data to be measured.|
The RangeSumfunction treats all non-numeric values as 0, unlike the + operator.
Examples and results:
|RangeSum (5,'abc')||Returns 5|
|RangeSum (null( ))|
Add the example script to your app and run it. Then add, at least, the fields listed in the results column to a sheet in your app to see the result.
LOAD recno() as RangeID, Rangesum(Field1,Field2,Field3) as MyRangeSum INLINE [
Field1, Field2, Field3
Please consult the help