topic Re: how to sum columns? in QlikView https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650866#M238038 <HTML><HEAD></HEAD><BODY><P>NumSum() does exactly the same thing like RangeSum(). In addition to that, the outer sum() you added is redundant.</P></BODY></HTML> Tue, 26 Aug 2014 08:59:30 GMT simondachstr 2014-08-26T08:59:30Z how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650858#M238030 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have several columns as below and I coded following code to sum all the columns but its not working </P><P><STRONG><EM>=sum(YY_CHANGE + CUTTING_SAVE + WRONG_OVER_TRANSFERS + RE_ORDERS + ERP_ISSUES + MOQ + IN_TOLERANCE + WRONG_OVER_TRANSFERS + DUPLICATE_P.O + BUYER_CHANGES + SUPPLIER_DELIVER_MORE + OTHER) </EM></STRONG></P><P></P><P>but its not working can any one help me </P><P></P><UL><LI>YY_CHANGE </LI><LI>CUTTING_SAVE </LI><LI>WRONG_OVER_TRANSFERS </LI><LI>RE_ORDERS</LI><LI>ERP_ISSUES</LI><LI>MOQ</LI><LI>IN_TOLERANCE</LI><LI>WRONG_OVER_TRANSFERS</LI><LI>DUPLICATE_P.O</LI><LI>BUYER_CHANGES</LI><LI>SUPPLIER_DELIVER_MORE</LI><LI>OTHER </LI></UL></BODY></HTML> Tue, 26 Aug 2014 08:48:17 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650858#M238030 2014-08-26T08:48:17Z Re: how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650859#M238031 <HTML><HEAD></HEAD><BODY><P>use rangesum(), like:</P><P>RangeSum(Field1, Field2,....Fieldn)</P><P>Or,</P><P>Simply Field1+Field2+...fieldn</P></BODY></HTML> Tue, 26 Aug 2014 08:50:40 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650859#M238031 tresB 2014-08-26T08:50:40Z Re: how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650860#M238032 <HTML><HEAD></HEAD><BODY><P>You could try adding them one at a time to debug it. Sum() isn't required you can just add them up.</P><P></P><P>Richard</P></BODY></HTML> Tue, 26 Aug 2014 08:50:55 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650860#M238032 richard_pearce6 2014-08-26T08:50:55Z Re: how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650861#M238033 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Just use</P><P>Column()</P><P></P><P>Like,</P><P>Column(1)+Column(2)+Column(3)+etc</P><P></P><P>Regards,</P></BODY></HTML> Tue, 26 Aug 2014 08:51:21 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650861#M238033 PrashantSangle 2014-08-26T08:51:21Z Re: how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650862#M238034 <HTML><HEAD></HEAD><BODY><P>Some field might contain null values. adding with null will become a null</P><P>Try like this</P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: inherit; font-weight: inherit;"><EM>=sum(NumSum(YY_CHANGE ,CUTTING_SAVE ,WRONG_OVER_TRANSFERS ,RE_ORDERS ,ERP_ISSUES ,MOQ ,IN_TOLERANCE ,WRONG_OVER_TRANSFERS ,DUPLICATE_P.O ,BUYER_CHANGES ,SUPPLIER_DELIVER_MORE ,OTHER))</EM></STRONG></SPAN></P></BODY></HTML> Tue, 26 Aug 2014 08:52:19 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650862#M238034 CELAMBARASAN 2014-08-26T08:52:19Z Re: how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650863#M238035 <HTML><HEAD></HEAD><BODY><P>Hi Mafaz.</P><P></P><P>You may want to do the sum in the script.</P><P></P><P><BR />Good luck.</P></BODY></HTML> Tue, 26 Aug 2014 08:54:58 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650863#M238035 christian77 2014-08-26T08:54:58Z Re: how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650864#M238036 <HTML><HEAD></HEAD><BODY><P>column() will only work if all fields are specifically used as expressions in a chart.</P></BODY></HTML> Tue, 26 Aug 2014 08:58:30 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650864#M238036 simondachstr 2014-08-26T08:58:30Z Re: how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650865#M238037 <HTML><HEAD></HEAD><BODY><P>I agree, except use RangeSum() rather than NumSum(). NumSum() is deprecated and will disappear in future, RangeSum() is the replacement for NumSum()</P></BODY></HTML> Tue, 26 Aug 2014 08:59:22 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650865#M238037 jonathandienst 2014-08-26T08:59:22Z Re: how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650866#M238038 <HTML><HEAD></HEAD><BODY><P>NumSum() does exactly the same thing like RangeSum(). In addition to that, the outer sum() you added is redundant.</P></BODY></HTML> Tue, 26 Aug 2014 08:59:30 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650866#M238038 simondachstr 2014-08-26T08:59:30Z Re: how to sum columns? https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650867#M238039 <HTML><HEAD></HEAD><BODY><P>can any one replay below link </P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/130575" title="http://community.qlik.com/thread/130575">http://community.qlik.com/thread/130575</A></P></BODY></HTML> Tue, 26 Aug 2014 09:26:34 GMT https://community.qlik.com/t5/QlikView/how-to-sum-columns/m-p/650867#M238039 2014-08-26T09:26:34Z