topic Re: convert values positive to negative and negative to positive in QlikView https://community.qlik.com/t5/QlikView/convert-values-positive-to-negative-and-negative-to-positive/m-p/830536#M1003521 <HTML><HEAD></HEAD><BODY><P>Thank you very much</P></BODY></HTML> Fri, 22 May 2015 05:43:35 GMT arulsettu 2015-05-22T05:43:35Z convert values positive to negative and negative to positive https://community.qlik.com/t5/QlikView/convert-values-positive-to-negative-and-negative-to-positive/m-p/830534#M1003518 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i am having a pivot table&nbsp; with positive and negative values. i want to convert the values negative to positive and positve to negative.</P><P>one of community friend said mupliply by -1. but the problem is i am having multiple if conditions so i am unable to write the condition</P><P></P><P>anyone please can guide me how to do it</P><P></P><P>Thanks</P></BODY></HTML> Fri, 22 May 2015 04:50:21 GMT https://community.qlik.com/t5/QlikView/convert-values-positive-to-negative-and-negative-to-positive/m-p/830534#M1003518 arulsettu 2015-05-22T04:50:21Z Re: convert values positive to negative and negative to positive https://community.qlik.com/t5/QlikView/convert-values-positive-to-negative-and-negative-to-positive/m-p/830535#M1003519 <HTML><HEAD></HEAD><BODY><P>You have an expression now. But parenthesis around the entire expression and put a - in front of it. If your expression starts with an = character then put that outside the parentheses, i.e. <EM>= -( ...complicated_expression_here ...)</EM> instead of <EM>-=( ...complicated_expression_here ...) </EM>or<EM> -(= ...complicated_expression_here ...). </EM>The last two are wrong.</P></BODY></HTML> Fri, 22 May 2015 05:25:02 GMT https://community.qlik.com/t5/QlikView/convert-values-positive-to-negative-and-negative-to-positive/m-p/830535#M1003519 Gysbert_Wassenaar 2015-05-22T05:25:02Z Re: convert values positive to negative and negative to positive https://community.qlik.com/t5/QlikView/convert-values-positive-to-negative-and-negative-to-positive/m-p/830536#M1003521 <HTML><HEAD></HEAD><BODY><P>Thank you very much</P></BODY></HTML> Fri, 22 May 2015 05:43:35 GMT https://community.qlik.com/t5/QlikView/convert-values-positive-to-negative-and-negative-to-positive/m-p/830536#M1003521 arulsettu 2015-05-22T05:43:35Z