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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
realpixel
Creator
Creator

Sum if null

Hello,

I have the following chart, I add expression

=(DELTA1 + DELTA2 + DELTA3 )

It's works fine if DELTA3 is not null.

The result of the first line should give:

14 + 0 + '-' = 14

Someone have an idea?

DELTA1DELTA2DELTA3DELTA1+DELTA2+DELTA3
140--
140--
60--
60--
80--
10--
90--
90--
110--
90--
60--
60--
60--
60--
60--
60--
60--
60--
330--
410041
130--
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

try you this:

(DELTA1 + DELTA2 + if(isnull(DELTA3),0,DELTA3) )

View solution in original post

3 Replies
Anonymous
Not applicable

Hi,

try you this:

(DELTA1 + DELTA2 + if(isnull(DELTA3),0,DELTA3) )

tresesco
MVP
MVP

Try like:

=RangeSum(DELTA1, DELTA2, DELTA3)

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

(DELTA1 + DELTA2 + alt(DELTA3, 0))


Best,

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!