topic Re: Create Negative number into positive in QlikView https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974870#M333301 <HTML><HEAD></HEAD><BODY><P>Have you look at the fabs() function? -&gt; <A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/fabs.htm?q=fabs" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/fabs.htm?q=fabs">QlikView ‒ Fabs - script and chart function</A></P></BODY></HTML> Tue, 22 Dec 2015 17:13:57 GMT sunny_talwar 2015-12-22T17:13:57Z Create Negative number into positive https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974869#M333300 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>Can anyone give me the number format to convert negative number to positive?</P><P></P><P>This is what I am looking for:</P><P></P><P>14.2% as 14.2%</P><P>-11.3% as 11.3%</P><P></P><P>Thanks in advance!</P><P>Regards,</P><P>Varun</P></BODY></HTML> Tue, 22 Dec 2015 17:13:15 GMT https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974869#M333300 varunreddy 2015-12-22T17:13:15Z Re: Create Negative number into positive https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974870#M333301 <HTML><HEAD></HEAD><BODY><P>Have you look at the fabs() function? -&gt; <A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/fabs.htm?q=fabs" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/fabs.htm?q=fabs">QlikView ‒ Fabs - script and chart function</A></P></BODY></HTML> Tue, 22 Dec 2015 17:13:57 GMT https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974870#M333301 sunny_talwar 2015-12-22T17:13:57Z Re: Create Negative number into positive https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974871#M333302 <HTML><HEAD></HEAD><BODY><P>Should I use it in expression?</P></BODY></HTML> Tue, 22 Dec 2015 17:16:33 GMT https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974871#M333302 varunreddy 2015-12-22T17:16:33Z Re: Create Negative number into positive https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974872#M333303 <HTML><HEAD></HEAD><BODY><P>Sure May be like this:</P><P></P><P><STRONG>Fabs(YourExpression)</STRONG></P></BODY></HTML> Tue, 22 Dec 2015 17:17:06 GMT https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974872#M333303 sunny_talwar 2015-12-22T17:17:06Z Re: Create Negative number into positive https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974873#M333304 <HTML><HEAD></HEAD><BODY><P>Thank You Sunny. Got to know some new function.</P><P></P><P>Regards,</P><P>Varun</P></BODY></HTML> Tue, 22 Dec 2015 17:18:23 GMT https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974873#M333304 varunreddy 2015-12-22T17:18:23Z Re: Create Negative number into positive https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974874#M333305 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 22 Dec 2015 17:19:59 GMT https://community.qlik.com/t5/QlikView/Create-Negative-number-into-positive/m-p/974874#M333305 sunny_talwar 2015-12-22T17:19:59Z