Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

rangesum?

rangesum(filed,0)   ?   what it returns

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

if field is numeric

whatever value of field, it will be returned

if Field is alphabate

0

If Field is Null

Null

View solution in original post

2 Replies
MK_QSL
MVP
MVP

if field is numeric

whatever value of field, it will be returned

if Field is alphabate

0

If Field is Null

Null

rwunderlich

"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