Discussion board where members can get started with QlikView.
Hi all , Can Any1 explain the use of range function with an example
Please check this
Range functions ‒ QlikView
what is the range of sum function ?
Awesome QlikView functions – Range – QlikTab
View solution in original post
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.
The RangeSumfunction treats all non-numeric values as 0, unlike the + operator.
Examples and results:
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