topic rangesum? in QlikView

rangesum?

Mon, 15 Dec 2014 16:05:51 GMT

rangesum(filed,0) ? what it returns

MK_QSL — Mon, 15 Dec 2014 16:14:05 GMT

if field is numeric

whatever value of field, it will be returned

if Field is alphabate

If Field is Null

Null

rwunderlich — Mon, 15 Dec 2014 17:56:51 GMT

"If Field is Null

Null"

I don't think that statement is true. From the Help for RangeSum():

"As opposed to the + operator, rangesum will treat all non-numeric values as 0. "

A Null in the Field vale will be treated as 0, and RangeSum() will return 0 in the example given.

-Rob