Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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!