Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
fadichmn
Contributor II
Contributor II

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])

View solution in original post

fadichmn
Contributor II
Contributor II
Author

This works correctly

fadichmn
Contributor II
Contributor II
Author

This works correctly, cheers guys!