Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is the range of sum function ?

hi to everyone can you please explain me .......... what is the range of sum function ?

3 Replies

Are you intending to ask for RangeSum() function??? If yes than you might find these link to be useful

Accumulative Sums

Calculating rolling n-period totals, averages or other aggregations



MVP & Luminary
MVP & Luminary

The rangesum function calculates the sum of the values passed to the function. All non-numeric values are treated as 0. That makes it useful if you have to deal with nulls and don't want a null as result. 11 + 2/0  will return null because 2 divided by 0 returns null. But rangesum(11, 2/0) will return 11.

talk is cheap, supply exceeds demand

I did not know that.

Good to know that as well. Thanks Gysbert Wassenaar