topic Re: Rangesum Above ,Below and Before,After and Range Avg in QlikView

Rangesum Above ,Below and Before,After and Range Avg

Sun, 19 Jan 2014 17:43:34 GMT

Hi ,

can any body expain RangeSum,RangeAvgfunction with above all properties

regards

Mahesh

Re: Rangesum Above ,Below and Before,After and Range Avg

Siva_Sankar — Mon, 20 Jan 2014 05:49:50 GMT

Find the attached file explaining the qlikview functions 'Rangesum Above ,Below and Before,After and Range Avg'

Regards.

Siva.

Re: Rangesum Above ,Below and Before,After and Range Avg

Mon, 20 Jan 2014 05:58:19 GMT

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

Re: Rangesum Above ,Below and Before,After and Range Avg

Mon, 20 Jan 2014 06:11:38 GMT

Below link may also help you ...

http://community.qlik.com/docs/DOC-4252

Re: Rangesum Above ,Below and Before,After and Range Avg

dineshraj — Wed, 17 Aug 2016 11:07:28 GMT

Hi siva,

I am new to qlik. can we use rangesum(avg,count) with set analysis like this?

rangesum({.......}field_name)

Re: Rangesum

NityaReddy — Thu, 04 Apr 2019 22:36:44 GMT

Hi,

Can someone help me figure out the formula to achieve the following:

Here is the what I currently have:

Order Num	MonthYear	Jan 2018	Feb 2018	Mar 2018	Apr 2018	May 2018
123123		22	10	12	25	12
345332		10	12	8	13	12
453456		32	32	32	32	32
766454		43	21	6	23	23

I am trying to write a formula where from the month of Feb the values get aggregated. Feb = Jan+Feb; Mar=Jan+Feb+Mar etc.,

Order Num	MonthYear	Jan 2018	Feb 2018	Mar 2018	Apr 2018	May 2018
123123		22	32	44	69	81
345332		10	22	30	43	55
453456		32	64	96	128	160
766454		43	64	70	93	116

I have attached the sample application