topic Re: Sum with null values in QlikView https://community.qlik.com/t5/QlikView/Sum-with-null-values/m-p/539442#M201561 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P></P><P>I was wandering is it possible to sum numbers with null value from two excels and condition A1 + A2 &gt;0 </P><P></P><P>Tab_1:</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp; A1&nbsp;&nbsp;&nbsp;&nbsp; A2 </P><P>XXX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>YYY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>ZZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp; </P><P></P><P>Tab_2:</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2</P><P>XXX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P>e.g.</P><P>I would like to get a result of </P><P>XXX&nbsp;&nbsp;&nbsp;&nbsp; 20+7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30+0&nbsp; = 27+30 = 57</P><P>YYY&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; = 7 </P><P></P><P>XXX&nbsp;&nbsp;&nbsp;&nbsp; 57</P><P>YYY&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P></P><P>sum ( (A1+A2)&gt;0 A1 + A2 )&nbsp; didn't work </P></BODY></HTML> Thu, 17 Apr 2014 11:09:01 GMT 2014-04-17T11:09:01Z Sum with null values https://community.qlik.com/t5/QlikView/Sum-with-null-values/m-p/539440#M201559 <HTML><HEAD></HEAD><BODY><P>Dears, </P><P></P><P>How can I sum 5 different collumns?</P><P>All of these columns can have null values...</P><P></P><P>I was trying to use the set analysis as follow, coz I would like to sum only if an specific creterias is match:</P><P>The Worktable was set as the sum of those 5 different collumns</P><P></P><P></P><P>TAB1+TAB2+TAB3+TAB4+TAB5 as WORKTABLE,</P><P></P><P></P><P>sum({$&lt;MOD = {MOD1}, Model -= {''}&gt;} WORKTABLE)</P><P></P><P>But It didn´t worked...</P><P></P><P>Thanks per your attention</P></BODY></HTML> Tue, 30 Jul 2013 14:26:20 GMT https://community.qlik.com/t5/QlikView/Sum-with-null-values/m-p/539440#M201559 2013-07-30T14:26:20Z Re: Sum with null values https://community.qlik.com/t5/QlikView/Sum-with-null-values/m-p/539441#M201560 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use Rangesum(TAB1, TAB2, ...) as WorkTable. </P><P>Like Sum, RangeSum treats nulls as zeroes.</P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Tue, 30 Jul 2013 14:32:00 GMT https://community.qlik.com/t5/QlikView/Sum-with-null-values/m-p/539441#M201560 jonathandienst 2013-07-30T14:32:00Z Re: Sum with null values https://community.qlik.com/t5/QlikView/Sum-with-null-values/m-p/539442#M201561 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P></P><P>I was wandering is it possible to sum numbers with null value from two excels and condition A1 + A2 &gt;0 </P><P></P><P>Tab_1:</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp; A1&nbsp;&nbsp;&nbsp;&nbsp; A2 </P><P>XXX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>YYY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>ZZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp; </P><P></P><P>Tab_2:</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2</P><P>XXX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P>e.g.</P><P>I would like to get a result of </P><P>XXX&nbsp;&nbsp;&nbsp;&nbsp; 20+7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30+0&nbsp; = 27+30 = 57</P><P>YYY&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; = 7 </P><P></P><P>XXX&nbsp;&nbsp;&nbsp;&nbsp; 57</P><P>YYY&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P></P><P>sum ( (A1+A2)&gt;0 A1 + A2 )&nbsp; didn't work </P></BODY></HTML> Thu, 17 Apr 2014 11:09:01 GMT https://community.qlik.com/t5/QlikView/Sum-with-null-values/m-p/539442#M201561 2014-04-17T11:09:01Z