topic Re: Subtraction in set in QlikView https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309263#M830717 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>Sum((Actual-Budget)/Price)</STRONG></P></BODY></HTML> Mon, 19 Jun 2017 16:43:20 GMT sunny_talwar 2017-06-19T16:43:20Z Subtraction in set https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309262#M830716 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I want to subtract 2&nbsp; fields at front end using set and want to multiply the result with another field.</P><P></P><P>Eg</P><P>There are 2 qtys say Actual and budget qty. I want to subtract budget qty from Actual qty. and result will be multiply by price</P><P>Say Actual qty is 10, Budget is 8 and price is 20. </P><P>I want (10-8)*20 as result</P><P></P><P></P><P>Please help!!!!!</P><P></P><P>Thank you..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309262#M830716 2020-11-25T16:16:04Z Re: Subtraction in set https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309263#M830717 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>Sum((Actual-Budget)/Price)</STRONG></P></BODY></HTML> Mon, 19 Jun 2017 16:43:20 GMT https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309263#M830717 sunny_talwar 2017-06-19T16:43:20Z Re: Subtraction in set https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309264#M830718 <HTML><HEAD></HEAD><BODY><P>Or this</P><P><STRONG>(Sum(Actual) - Sum(Budget))/Sum(Price)</STRONG></P></BODY></HTML> Mon, 19 Jun 2017 16:43:50 GMT https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309264#M830718 sunny_talwar 2017-06-19T16:43:50Z Re: Subtraction in set https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309265#M830719 <HTML><HEAD></HEAD><BODY><P>Thanks..It works..</P></BODY></HTML> Tue, 20 Jun 2017 05:50:55 GMT https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309265#M830719 2017-06-20T05:50:55Z Re: Subtraction in set https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309266#M830720 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).</P><P>If not, please make clear what part of this topic you still need help with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Tue, 20 Jun 2017 06:40:08 GMT https://community.qlik.com/t5/QlikView/Subtraction-in-set/m-p/1309266#M830720 oknotsen 2017-06-20T06:40:08Z