
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rangesum Above ,Below and Before,After and Range Avg
Hi ,
can any body expain RangeSum,RangeAvgfunction with above all properties
regards
Mahesh
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Find the attached file explaining the qlikview functions 'Rangesum Above ,Below and Before,After and Range Avg'
Regards.
Siva.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Find the attached file explaining the qlikview functions 'Rangesum Above ,Below and Before,After and Range Avg'
Regards.
Siva.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Below link may also help you ...


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi siva,
I am new to qlik. can we use rangesum(avg,count) with set analysis like this?
rangesum({.......}field_name)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
