Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
fadichmn
New 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.

Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: RangeSum is showing 0 instead of value

Use comma separated two arguments:

RangeSum([FieldA], [FieldB])

View solution in original post

4 Replies
Highlighted
Frank_Hartmann
Honored Contributor II

Re: RangeSum is showing 0 instead of value

sum(FieldA)+sum(FieldB)

hope this helps

Highlighted
MVP
MVP

Re: RangeSum is showing 0 instead of value

Use comma separated two arguments:

RangeSum([FieldA], [FieldB])

View solution in original post

Highlighted
fadichmn
New Contributor II

Re: RangeSum is showing 0 instead of value

This works correctly

Highlighted
fadichmn
New Contributor II

Re: RangeSum is showing 0 instead of value

This works correctly, cheers guys!