topic Re: Assign negative values to variable values in QlikView https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166249#M887573 <HTML><HEAD></HEAD><BODY><P>This should work if you are using this as calculated field in the LOAD script or a UI expression.</P><P></P><P>Also, your Quantity values should be numeric, not just pure text values.</P></BODY></HTML> Thu, 08 Sep 2016 16:17:08 GMT swuehl 2016-09-08T16:17:08Z Assign negative values to variable values https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166248#M887572 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i have a very simple question, in which i wasn't able to find a solution from google.</P><P></P><P>Here is the sample of my table: </P><P></P><P>Item</P><P>Quantity</P><P>Price</P><P></P><P>I just want to make all Quantity values negative. I tried Quantity*(-1) but it didn't work. Can anyone please suggest a way to acomplish that?</P><P></P><P>Thank you in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166248#M887572 2020-11-25T16:16:04Z Re: Assign negative values to variable values https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166249#M887573 <HTML><HEAD></HEAD><BODY><P>This should work if you are using this as calculated field in the LOAD script or a UI expression.</P><P></P><P>Also, your Quantity values should be numeric, not just pure text values.</P></BODY></HTML> Thu, 08 Sep 2016 16:17:08 GMT https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166249#M887573 swuehl 2016-09-08T16:17:08Z Re: Assign negative values to variable values https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166250#M887574 <HTML><HEAD></HEAD><BODY><P>It should work.. Can you post your variable expression !!</P></BODY></HTML> Thu, 08 Sep 2016 16:17:56 GMT https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166250#M887574 Anonymous 2016-09-08T16:17:56Z Re: Assign negative values to variable values https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166251#M887575 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>num#(Quantity,'#')*-1 as Quantity</P></BODY></HTML> Thu, 08 Sep 2016 18:03:44 GMT https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166251#M887575 Anonymous 2016-09-08T18:03:44Z Re: Assign negative values to variable values https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166252#M887576 <HTML><HEAD></HEAD><BODY><P>It worked finally! Thanks for your suggestions</P></BODY></HTML> Fri, 09 Sep 2016 06:10:08 GMT https://community.qlik.com/t5/QlikView/Assign-negative-values-to-variable-values/m-p/1166252#M887576 2016-09-09T06:10:08Z