https://community.qlik.com/t5/App-Development/Negative-value-as-positive-values/m-p/1517486#M36954 <P>Dear all!</P><P>I´m having a case that the orignal data that is loaded is both positive and negative values.</P><P>How could I write my expression so that the negative values are loaded as positve values. i.e. no "-" Before the value.</P><P>Do anyone have a solution?</P><P>Best regards</P> Thu, 06 Dec 2018 14:59:22 GMT richards 2018-12-06T14:59:22Z https://community.qlik.com/t5/App-Development/Negative-value-as-positive-values/m-p/1517486#M36954 <P>Dear all!</P><P>I´m having a case that the orignal data that is loaded is both positive and negative values.</P><P>How could I write my expression so that the negative values are loaded as positve values. i.e. no "-" Before the value.</P><P>Do anyone have a solution?</P><P>Best regards</P> Thu, 06 Dec 2018 14:59:22 GMT https://community.qlik.com/t5/App-Development/Negative-value-as-positive-values/m-p/1517486#M36954 richards 2018-12-06T14:59:22Z https://community.qlik.com/t5/App-Development/Negative-value-as-positive-values/m-p/1517488#M36955 Hi,<BR /><BR />On load use the Fabs() function like below.<BR />Fabs(Field) as Field.<BR /><BR />Mark Thu, 06 Dec 2018 15:01:26 GMT https://community.qlik.com/t5/App-Development/Negative-value-as-positive-values/m-p/1517488#M36955 Mark_Little 2018-12-06T15:01:26Z https://community.qlik.com/t5/App-Development/Negative-value-as-positive-values/m-p/1517489#M36956 <P>Use fabs() function....</P><PRE>fabs(FieldName) as FieldName</PRE> Thu, 06 Dec 2018 15:01:29 GMT https://community.qlik.com/t5/App-Development/Negative-value-as-positive-values/m-p/1517489#M36956 sunny_talwar 2018-12-06T15:01:29Z https://community.qlik.com/t5/App-Development/Negative-value-as-positive-values/m-p/1517807#M37024 <P>Thanks for the answer.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 07 Dec 2018 08:38:05 GMT https://community.qlik.com/t5/App-Development/Negative-value-as-positive-values/m-p/1517807#M37024 richards 2018-12-07T08:38:05Z