topic Re: Sum Positive and Negative Numbers qlikview Regardless of Sign in QlikView https://community.qlik.com/t5/QlikView/Sum-Positive-and-Negative-Numbers-qlikview-Regardless-of-Sign/m-p/516206#M552421 <HTML><HEAD></HEAD><BODY><P>Hi Vikas,</P><P></P><P>Try like this</P><P></P><P>=Fabs(<SPAN style="color: #800000;">DOCNUM</SPAN>)+ <SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">DMSDOCNUM</SPAN>)</P><P></P><P>If it is not working then check with if like this</P><P></P><P>if(Number &lt; 0, Number * -1, Number)</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 24 Oct 2013 03:08:37 GMT jagan 2013-10-24T03:08:37Z Sum Positive and Negative Numbers qlikview Regardless of Sign https://community.qlik.com/t5/QlikView/Sum-Positive-and-Negative-Numbers-qlikview-Regardless-of-Sign/m-p/516203#M552418 <HTML><HEAD></HEAD><BODY><P><BR /><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">Hi All,</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">Is it possible to get sum of negative and positive Numbers Regardsless of sign.I am using this expression (<SPAN style="color: #800000;">DOCNUM</SPAN>)-<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">DMSDOCNUM</SPAN>) but it is not solving my problem. i Should be getting around 35000 records but beacuse of negative and positie sign i am only getting 2700 records.</SPAN></P><P> </P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">Can anyone please help me with this.&nbsp; Attaching my case scneraio here.</SPAN></P><P> </P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">Regards,</SPAN></P><P><SPAN style="font-size: 12pt; font-family: arial,helvetica,sans-serif;">vikas</SPAN></P><P></P></BODY></HTML> Thu, 24 Oct 2013 00:06:58 GMT https://community.qlik.com/t5/QlikView/Sum-Positive-and-Negative-Numbers-qlikview-Regardless-of-Sign/m-p/516203#M552418 2013-10-24T00:06:58Z Re: Sum Positive and Negative Numbers qlikview Regardless of Sign https://community.qlik.com/t5/QlikView/Sum-Positive-and-Negative-Numbers-qlikview-Regardless-of-Sign/m-p/516204#M552419 <HTML><HEAD></HEAD><BODY><P>use</P><P></P><P>=fabs()</P></BODY></HTML> Thu, 24 Oct 2013 01:42:28 GMT https://community.qlik.com/t5/QlikView/Sum-Positive-and-Negative-Numbers-qlikview-Regardless-of-Sign/m-p/516204#M552419 Alejandro_Hernández 2013-10-24T01:42:28Z Re: Sum Positive and Negative Numbers qlikview Regardless of Sign https://community.qlik.com/t5/QlikView/Sum-Positive-and-Negative-Numbers-qlikview-Regardless-of-Sign/m-p/516205#M552420 <HTML><HEAD></HEAD><BODY><P>Hey Alejandro,</P><P></P><P>I tried that but its not working! Do you have any other sugession?</P><P></P><P>Regards,</P><P>Vikas</P></BODY></HTML> Thu, 24 Oct 2013 01:50:41 GMT https://community.qlik.com/t5/QlikView/Sum-Positive-and-Negative-Numbers-qlikview-Regardless-of-Sign/m-p/516205#M552420 2013-10-24T01:50:41Z Re: Sum Positive and Negative Numbers qlikview Regardless of Sign https://community.qlik.com/t5/QlikView/Sum-Positive-and-Negative-Numbers-qlikview-Regardless-of-Sign/m-p/516206#M552421 <HTML><HEAD></HEAD><BODY><P>Hi Vikas,</P><P></P><P>Try like this</P><P></P><P>=Fabs(<SPAN style="color: #800000;">DOCNUM</SPAN>)+ <SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">DMSDOCNUM</SPAN>)</P><P></P><P>If it is not working then check with if like this</P><P></P><P>if(Number &lt; 0, Number * -1, Number)</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 24 Oct 2013 03:08:37 GMT https://community.qlik.com/t5/QlikView/Sum-Positive-and-Negative-Numbers-qlikview-Regardless-of-Sign/m-p/516206#M552421 jagan 2013-10-24T03:08:37Z