Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
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
sunny_talwar

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

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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
sunny_talwar

I did not know that.

Good to know that as well. Thanks Gysbert Wassenaar