topic Converting negative values into a positive one in QlikView https://community.qlik.com/t5/QlikView/Converting-negative-values-into-a-positive-one/m-p/427253#M491103 <HTML><HEAD></HEAD><BODY><P>Can someone please help me combine the 2 expressions below into 1? </P><P></P><P>Expression 1) =FABS(SUM([Data]))/100</P><P>Expression 2) Aggr(Sum (Data), [Test Description])</P><P></P><P>Thanks</P></BODY></HTML> Thu, 20 Sep 2012 21:12:24 GMT 2012-09-20T21:12:24Z Converting negative values into a positive one https://community.qlik.com/t5/QlikView/Converting-negative-values-into-a-positive-one/m-p/427253#M491103 <HTML><HEAD></HEAD><BODY><P>Can someone please help me combine the 2 expressions below into 1? </P><P></P><P>Expression 1) =FABS(SUM([Data]))/100</P><P>Expression 2) Aggr(Sum (Data), [Test Description])</P><P></P><P>Thanks</P></BODY></HTML> Thu, 20 Sep 2012 21:12:24 GMT https://community.qlik.com/t5/QlikView/Converting-negative-values-into-a-positive-one/m-p/427253#M491103 2012-09-20T21:12:24Z Re: Converting negative values into a positive one https://community.qlik.com/t5/QlikView/Converting-negative-values-into-a-positive-one/m-p/427254#M491104 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Try like something,</P><P></P><P> Aggr(Sum (Fabs(Data))/100, [Test Description])</P><P></P><P>or</P><P></P><P> Aggr(Sum (Fabs(Data)), [Test Description])/100</P></BODY></HTML> Thu, 20 Sep 2012 21:14:54 GMT https://community.qlik.com/t5/QlikView/Converting-negative-values-into-a-positive-one/m-p/427254#M491104 MayilVahanan 2012-09-20T21:14:54Z Re: Converting negative values into a positive one https://community.qlik.com/t5/QlikView/Converting-negative-values-into-a-positive-one/m-p/427255#M491105 <HTML><HEAD></HEAD><BODY><P>As per your expression it will be like</P><P>Fabs(Sum(Aggr(Sum(Data),[TestDescription])))/100</P><P>or</P><P>Fabs(Aggr(Sum(Data),[TestDescription]))/100</P></BODY></HTML> Thu, 20 Sep 2012 21:45:28 GMT https://community.qlik.com/t5/QlikView/Converting-negative-values-into-a-positive-one/m-p/427255#M491105 CELAMBARASAN 2012-09-20T21:45:28Z Re: Converting negative values into a positive one https://community.qlik.com/t5/QlikView/Converting-negative-values-into-a-positive-one/m-p/427256#M491106 <HTML><HEAD></HEAD><BODY><P>thank you!</P></BODY></HTML> Fri, 21 Sep 2012 12:18:52 GMT https://community.qlik.com/t5/QlikView/Converting-negative-values-into-a-positive-one/m-p/427256#M491106 2012-09-21T12:18:52Z