topic Re: Sum if null in QlikView https://community.qlik.com/t5/QlikView/Sum-if-null/m-p/501089#M187248 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>=RangeSum(DELTA1, DELTA2, DELTA3)</P></BODY></HTML> Wed, 27 Nov 2013 17:13:06 GMT tresB 2013-11-27T17:13:06Z Sum if null https://community.qlik.com/t5/QlikView/Sum-if-null/m-p/501087#M187246 <HTML><HEAD></HEAD><BODY><P> Hello,</P><P></P><P> I have the following chart, I add expression </P><P></P><P>=(DELTA1 + DELTA2 + DELTA3 ) </P><P></P><P>It's works fine if DELTA3 is not null.</P><P></P><P>The result of the first line should give:</P><P>14 + 0 + '-' = 14</P><P></P><P>Someone have an idea?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 409px;"><TBODY><TR><TD class="xl66" height="17" width="80">DELTA1</TD><TD class="xl66" width="80">DELTA2</TD><TD class="xl66" width="80">DELTA3</TD><TD class="xl66" width="169">DELTA1+DELTA2+DELTA3</TD></TR><TR><TD align="right" class="xl63" height="17">14</TD><TD align="right" class="xl64" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">0</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">-</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">14</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">8</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">1</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">9</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">9</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">11</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">9</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">6</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">33</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">41</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">41</TD></TR><TR><TD align="right" class="xl63" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">13</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 27 Nov 2013 17:08:37 GMT https://community.qlik.com/t5/QlikView/Sum-if-null/m-p/501087#M187246 realpixel 2013-11-27T17:08:37Z Re: Sum if null https://community.qlik.com/t5/QlikView/Sum-if-null/m-p/501088#M187247 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try you this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">(DELTA1 + DELTA2 + if(isnull(DELTA3),0,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DELTA3</SPAN>) )</SPAN></P></BODY></HTML> Wed, 27 Nov 2013 17:12:07 GMT https://community.qlik.com/t5/QlikView/Sum-if-null/m-p/501088#M187247 Anonymous 2013-11-27T17:12:07Z Re: Sum if null https://community.qlik.com/t5/QlikView/Sum-if-null/m-p/501089#M187248 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>=RangeSum(DELTA1, DELTA2, DELTA3)</P></BODY></HTML> Wed, 27 Nov 2013 17:13:06 GMT https://community.qlik.com/t5/QlikView/Sum-if-null/m-p/501089#M187248 tresB 2013-11-27T17:13:06Z Re: Sum if null https://community.qlik.com/t5/QlikView/Sum-if-null/m-p/501090#M187249 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">(DELTA1 + DELTA2 + alt(DELTA3, 0))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Best,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Aurélien<BR /></SPAN></P></BODY></HTML> Wed, 27 Nov 2013 17:14:05 GMT https://community.qlik.com/t5/QlikView/Sum-if-null/m-p/501090#M187249 Aurelien_Martinez 2013-11-27T17:14:05Z