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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

RangeSum is showing 0 instead of value

Hello,

I am using this expression to get the Total value of the fields but I get 0 value anyway and I want to show the full value, in this case: 2

FieldA has value 2, FieldB is null.

Expression: RangeSum([FieldA]+[FieldB])

FieldAFieldBTotal
20

Is there any trick here? I also tried with sum/count.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Use comma separated two arguments:

RangeSum([FieldA], [FieldB])

View solution in original post

4 Replies
Frank_Hartmann
Master II
Master II

sum(FieldA)+sum(FieldB)

hope this helps

swuehl
MVP
MVP

Use comma separated two arguments:

RangeSum([FieldA], [FieldB])

Anonymous
Not applicable
Author

This works correctly

Anonymous
Not applicable
Author

This works correctly, cheers guys!