Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Best,

Sunny

Highlighted
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
Highlighted

I did not know that.

Good to know that as well. Thanks Gysbert Wassenaar