topic Re: use of total when fabs is used in QlikView https://community.qlik.com/t5/QlikView/use-of-total-when-fabs-is-used/m-p/428664#M159776 <HTML><HEAD></HEAD><BODY><P>Could you send sample qvw file?</P></BODY></HTML> Wed, 12 Dec 2012 13:39:44 GMT 2012-12-12T13:39:44Z use of total when fabs is used https://community.qlik.com/t5/QlikView/use-of-total-when-fabs-is-used/m-p/428663#M159775 <HTML><HEAD></HEAD><BODY><P>Sum <SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TRX</SPAN><SPAN style="font-size: 8pt;">)/(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TRX</SPAN><SPAN style="font-size: 8pt;">))/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ZIP_CODE</SPAN><SPAN style="font-size: 8pt;">)))&nbsp; - this formula works fine but i am facing issues when i replicate this formula in another expression which is</SPAN></P><P></P><P></P><P></P><P></P><P></P><P>fabs(Sum(TRX)-(Sum ({$&lt;WEEK_END_DATE={"$(=date( max(WEEK_END_DATE)-7))"}&gt;}TRX)))</P><P>/</P><P>(sum(TOTAL(fabs(Sum(TRX)-(Sum ({$&lt;WEEK_END_DATE={"$(=date( max(WEEK_END_DATE)-7))"}&gt;}TRX))))))/ (Count(DISTINCT(ZIP_CODE)))</P><P></P><P></P><P><SPAN style="font-size: 8pt;"><BR />can anyone tell me where im going wrong, the formula does&nbsp; not show an error<BR /> </SPAN></P></BODY></HTML> Wed, 12 Dec 2012 06:41:59 GMT https://community.qlik.com/t5/QlikView/use-of-total-when-fabs-is-used/m-p/428663#M159775 2012-12-12T06:41:59Z Re: use of total when fabs is used https://community.qlik.com/t5/QlikView/use-of-total-when-fabs-is-used/m-p/428664#M159776 <HTML><HEAD></HEAD><BODY><P>Could you send sample qvw file?</P></BODY></HTML> Wed, 12 Dec 2012 13:39:44 GMT https://community.qlik.com/t5/QlikView/use-of-total-when-fabs-is-used/m-p/428664#M159776 2012-12-12T13:39:44Z Re: use of total when fabs is used https://community.qlik.com/t5/QlikView/use-of-total-when-fabs-is-used/m-p/428665#M159777 <HTML><HEAD></HEAD><BODY><P>Sum over the sum is not possible.</P><P>Can you tell me what is your requirement?</P><P>Aggr is the only way to use sum over the sum like</P><P>Sum(Total Aggr(Fabs(Sum(FieldName)), DimField))</P></BODY></HTML> Wed, 12 Dec 2012 17:20:37 GMT https://community.qlik.com/t5/QlikView/use-of-total-when-fabs-is-used/m-p/428665#M159777 CELAMBARASAN 2012-12-12T17:20:37Z