topic Re: how to load files with negative values in App Development https://community.qlik.com/t5/App-Development/how-to-load-files-with-negative-values/m-p/1507568#M36268 <P>You have to use FABS function.</P><P><A href="https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/GeneralNumericFunctions/fabs.htm" target="_blank">https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/GeneralNumericFunctions/fabs.htm</A></P> Thu, 15 Nov 2018 20:26:04 GMT jayanttibhe 2018-11-15T20:26:04Z how to load files with negative values https://community.qlik.com/t5/App-Development/how-to-load-files-with-negative-values/m-p/1507375#M36265 <P>I have the following information:</P><P>account: -4000<BR />account aa: -2000<BR />aaa account: 1000</P><P>when it is loaded the result is all positive</P><P><SPAN>account:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4000</SPAN><BR /><SPAN>account aa:&nbsp; &nbsp; 2000</SPAN><BR /><SPAN>aaa account: 1000</SPAN></P> Thu, 15 Nov 2018 15:00:27 GMT https://community.qlik.com/t5/App-Development/how-to-load-files-with-negative-values/m-p/1507375#M36265 alextobias 2018-11-15T15:00:27Z Re: how to load files with negative values https://community.qlik.com/t5/App-Development/how-to-load-files-with-negative-values/m-p/1507401#M36266 <P>Can you try loading the value as a Num?&nbsp; As in Num(AccountValueField) ?</P> Thu, 15 Nov 2018 15:25:19 GMT https://community.qlik.com/t5/App-Development/how-to-load-files-with-negative-values/m-p/1507401#M36266 JustinDallas 2018-11-15T15:25:19Z Re: how to load files with negative values https://community.qlik.com/t5/App-Development/how-to-load-files-with-negative-values/m-p/1507503#M36267 <P>yes, the value is a negative number</P> Thu, 15 Nov 2018 17:36:53 GMT https://community.qlik.com/t5/App-Development/how-to-load-files-with-negative-values/m-p/1507503#M36267 alextobias 2018-11-15T17:36:53Z Re: how to load files with negative values https://community.qlik.com/t5/App-Development/how-to-load-files-with-negative-values/m-p/1507568#M36268 <P>You have to use FABS function.</P><P><A href="https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/GeneralNumericFunctions/fabs.htm" target="_blank">https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/GeneralNumericFunctions/fabs.htm</A></P> Thu, 15 Nov 2018 20:26:04 GMT https://community.qlik.com/t5/App-Development/how-to-load-files-with-negative-values/m-p/1507568#M36268 jayanttibhe 2018-11-15T20:26:04Z