topic Function for absolute values in QlikView https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148903#M27125 <HTML><HEAD></HEAD><BODY><P>Is there any function in QlikView Developer for absolute values like abs() in Excel?</P><P></P></BODY></HTML> Thu, 09 Jul 2009 19:14:22 GMT 2009-07-09T19:14:22Z Function for absolute values https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148903#M27125 <HTML><HEAD></HEAD><BODY><P>Is there any function in QlikView Developer for absolute values like abs() in Excel?</P><P></P></BODY></HTML> Thu, 09 Jul 2009 19:14:22 GMT https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148903#M27125 2009-07-09T19:14:22Z Function for absolute values https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148904#M27126 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I thinks <B>FABS()</B> will help you.</P><P style="font-weight: bold">- Sridhar</P></BODY></HTML> Thu, 09 Jul 2009 19:30:49 GMT https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148904#M27126 2009-07-09T19:30:49Z Re: Function for absolute values https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148905#M27127 <HTML><HEAD></HEAD><BODY><P>Great, Thank you!</P></BODY></HTML> Thu, 09 Jul 2009 19:41:09 GMT https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148905#M27127 2009-07-09T19:41:09Z Re: Function for absolute values https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148906#M27128 <HTML><HEAD></HEAD><BODY><P>Very helpful, thanks Sridhar.</P><P></P><P><A href="https://community.qlik.com/qlik-users/4815">Fredrik Quirin</A> will you pls mark this as answered so that it can help more people? Tks.</P></BODY></HTML> Thu, 26 Sep 2013 08:54:17 GMT https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148906#M27128 2013-09-26T08:54:17Z Re: Function for absolute values https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148907#M27129 <HTML><HEAD></HEAD><BODY><P>Where Field1 is dimension</P><P></P><P>fabs(sum(Amount)/sum(TOTAL {&lt;Amount={"&gt;=0"}&gt;}Amount)*100)</P></BODY></HTML> Mon, 10 Feb 2014 14:44:32 GMT https://community.qlik.com/t5/QlikView/Function-for-absolute-values/m-p/148907#M27129 2014-02-10T14:44:32Z