topic Sum of columns with nullvalue in QlikView https://community.qlik.com/t5/QlikView/Sum-of-columns-with-nullvalue/m-p/289056#M107402 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've a problem with correct sum of column.</P><P>I would like sum A+B+C+D</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp;&nbsp;&nbsp;&nbsp; E(A+B+C+D)</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; wrong value </P><P>1&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; wrong value</P><P></P><P>where fields value = NULL the equal&nbsp; = 0</P></BODY></HTML> Thu, 16 Feb 2012 10:44:29 GMT 2012-02-16T10:44:29Z Sum of columns with nullvalue https://community.qlik.com/t5/QlikView/Sum-of-columns-with-nullvalue/m-p/289056#M107402 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've a problem with correct sum of column.</P><P>I would like sum A+B+C+D</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp;&nbsp;&nbsp;&nbsp; E(A+B+C+D)</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; wrong value </P><P>1&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; wrong value</P><P></P><P>where fields value = NULL the equal&nbsp; = 0</P></BODY></HTML> Thu, 16 Feb 2012 10:44:29 GMT https://community.qlik.com/t5/QlikView/Sum-of-columns-with-nullvalue/m-p/289056#M107402 2012-02-16T10:44:29Z Re: Sum of columns with nullvalue https://community.qlik.com/t5/QlikView/Sum-of-columns-with-nullvalue/m-p/289057#M107403 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Use the rangesum function to solve this problem</P><P>&nbsp;&nbsp;&nbsp;&nbsp; =RangeSum(A,B,C,D)</P><P></P><P>Celambarasan</P></BODY></HTML> Thu, 16 Feb 2012 10:46:17 GMT https://community.qlik.com/t5/QlikView/Sum-of-columns-with-nullvalue/m-p/289057#M107403 CELAMBARASAN 2012-02-16T10:46:17Z