Range Function

[vignesh_s]

Hi all , Can Any1 explain the use of range function with an example

[prma7799 · Accepted solution]

Please check this

Range functions ‒ QlikView

what is the range of sum function ?

Awesome QlikView functions – Range – QlikTab

[pradosh_thakur]

hi Vignesh

please close your open threads if you are satisfied or feel free to ask questions.

[shiveshsingh]

Pasted from Help:

RangeSum() returns the sum of a range of values.All non-numeric values are treated as 0, unlike the + operator.

Syntax:

RangeSum(first_expr[, Expression])

Return data type: numeric

Arguments:

The arguments of this function may contain inter-record functions which in themselves return a list of values.

Argument	Description
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.

Limitations:

The RangeSumfunction treats all non-numeric values as 0, unlike the + operator.

Examples and results:

Examples	Results
RangeSum (1,2,4)	Returns 7
RangeSum (5,'abc')	Returns 5
RangeSum (null( ))	Returns 0
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. RangeTab3: LOAD recno() as RangeID, Rangesum(Field1,Field2,Field3) as MyRangeSum INLINE [ Field1, Field2, Field3 10,5,6 2,3,7 8,2,8 18,11,9 5,5,9 9,4,2 ];	The resulting table shows the returned values of MyRangeSum for each of the records in the table. RangeID MyRangeSum 1 21 2 12 3 18 4 38 5 19 6 15

[Anonymous]

HI Vignesh

Please consult the help