Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
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