topic Re: How to minus the values in text object? in QlikView https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73208#M767730 <HTML><HEAD></HEAD><BODY><P>Thanks for speedy reply guys!! </P></BODY></HTML> Mon, 25 Jun 2018 15:58:03 GMT Anonymous 2018-06-25T15:58:03Z How to minus the values in text object? https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73204#M767726 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I have a value as 250 in one text <SPAN style="font-size: 13.3333px;">object </SPAN>and 150 in another text object, now need to minus those value and put into new text object.</P><P></P><P>How to use minus operator in qlikview!?</P><P></P><P><STRONG>Regards,</STRONG></P><P><STRONG>Ashok Ravichandran</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73204#M767726 Anonymous 2020-11-25T16:16:04Z Re: How to minus the values in text object? https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73205#M767727 <HTML><HEAD></HEAD><BODY><P>you can use </P><P>(Exp1 - Exp2)</P><P></P><P>Where Exp1 give you 250 and Exp 2 give you 150</P></BODY></HTML> Mon, 25 Jun 2018 09:53:57 GMT https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73205#M767727 vipin_mishra479 2018-06-25T09:53:57Z Re: How to minus the values in text object? https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73206#M767728 <HTML><HEAD></HEAD><BODY><P>You can also use RangeSum() like this</P><P></P><P><STRONG>=RangeSum(</STRONG><STRONG>Exp1, </STRONG><STRONG>-Exp2)</STRONG></P></BODY></HTML> Mon, 25 Jun 2018 11:04:38 GMT https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73206#M767728 sunny_talwar 2018-06-25T11:04:38Z Re: How to minus the values in text object? https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73207#M767729 <HTML><HEAD></HEAD><BODY><P>Use variables like Let v1 = Exp1; <SPAN style="font-size: 13.3333px;">Let v2 = Exp2;</SPAN></P><P><SPAN style="font-size: 13.3333px;">($(v1)-$(v2))</SPAN></P></BODY></HTML> Mon, 25 Jun 2018 13:03:56 GMT https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73207#M767729 rajeshqvd 2018-06-25T13:03:56Z Re: How to minus the values in text object? https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73208#M767730 <HTML><HEAD></HEAD><BODY><P>Thanks for speedy reply guys!! </P></BODY></HTML> Mon, 25 Jun 2018 15:58:03 GMT https://community.qlik.com/t5/QlikView/How-to-minus-the-values-in-text-object/m-p/73208#M767730 Anonymous 2018-06-25T15:58:03Z