topic Re: how to make absolute sum? in QlikView https://community.qlik.com/t5/QlikView/how-to-make-absolute-sum/m-p/427801#M489983 <HTML><HEAD></HEAD><BODY><P>Well, i got the solution.</P><P></P><P>The calcutlation was doing the sum of the gap in each row.</P><P></P><P>So, if we are doing it like this fabs( sum (a - b)&nbsp; ) , the total value will still take the minus sign into the calculation.</P><P></P><P>But, this <STRONG>sum( fabs( a - b ) )</STRONG> , will fix the problem.</P></BODY></HTML> Wed, 14 Nov 2012 16:22:17 GMT 2012-11-14T16:22:17Z how to make absolute sum? https://community.qlik.com/t5/QlikView/how-to-make-absolute-sum/m-p/427800#M489982 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm doing fabs(sum(a) - sum(b)) , in a pivot table.</P><P>by row, the calculation is good. all figures are in positive.</P><P></P><P>but, the partial total in pivot is not good, it still do the sum according to the original negative values...</P><P></P><P>any helps please...</P></BODY></HTML> Tue, 13 Nov 2012 09:52:06 GMT https://community.qlik.com/t5/QlikView/how-to-make-absolute-sum/m-p/427800#M489982 2012-11-13T09:52:06Z Re: how to make absolute sum? https://community.qlik.com/t5/QlikView/how-to-make-absolute-sum/m-p/427801#M489983 <HTML><HEAD></HEAD><BODY><P>Well, i got the solution.</P><P></P><P>The calcutlation was doing the sum of the gap in each row.</P><P></P><P>So, if we are doing it like this fabs( sum (a - b)&nbsp; ) , the total value will still take the minus sign into the calculation.</P><P></P><P>But, this <STRONG>sum( fabs( a - b ) )</STRONG> , will fix the problem.</P></BODY></HTML> Wed, 14 Nov 2012 16:22:17 GMT https://community.qlik.com/t5/QlikView/how-to-make-absolute-sum/m-p/427801#M489983 2012-11-14T16:22:17Z Re: how to make absolute sum? https://community.qlik.com/t5/QlikView/how-to-make-absolute-sum/m-p/427802#M489984 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>This will work only if you have one a and b value for each of your dimension values.</P><P>More common solution is:</P><P>=sum(aggr(fabs(sum(a)-sum(b)), Dimesnion)))</P></BODY></HTML> Wed, 14 Nov 2012 18:11:09 GMT https://community.qlik.com/t5/QlikView/how-to-make-absolute-sum/m-p/427802#M489984 whiteline 2012-11-14T18:11:09Z