Range Function

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Range Function

pradosh_thakur — Sat, 30 Dec 2017 12:47:17 GMT

hi Vignesh

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

Re: Range Function

shiveshsingh — Sun, 31 Dec 2017 03:45:23 GMT

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

Re: Range Function

Anonymous — Tue, 02 Jan 2018 14:25:54 GMT

HI Vignesh

Please consult the help

topic Re: Range Function in QlikView

Range Function

Re: Range Function

Re: Range Function

Re: Range Function

Re: Range Function