topic Re: Subtracting in Set Analysis!! in QlikView https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335230#M835581 <HTML><HEAD></HEAD><BODY><P>Good, Close this thread</P></BODY></HTML> Thu, 25 May 2017 08:29:25 GMT Anil_Babu_Samineni 2017-05-25T08:29:25Z Subtracting in Set Analysis!! https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335224#M835575 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Can someone tell me what's wrong with this syntax. I am trying to calculate a difference two values in set analysis?</P><P></P><P>=Max({$&lt;Quality={'Timber'}&gt;}USD_AMT*[Tons])-Min({$&lt;Quality={'Pulp'}&gt;}USD_AMT*[Tons])&nbsp; to get total amount.</P><P></P><P>Request you to please look into this issue.</P><P></P><P>Thanks</P><P>Satyendra</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335224#M835575 Anonymous 2020-11-25T16:16:04Z Re: Subtracting in Set Analysis!! https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335225#M835576 <HTML><HEAD></HEAD><BODY><P>Seems expression ok to me, What was the error?</P></BODY></HTML> Thu, 25 May 2017 06:54:54 GMT https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335225#M835576 Anil_Babu_Samineni 2017-05-25T06:54:54Z Re: Subtracting in Set Analysis!! https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335226#M835577 <HTML><HEAD></HEAD><BODY><P>Please some sample app&nbsp; </P></BODY></HTML> Thu, 25 May 2017 06:56:08 GMT https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335226#M835577 prma7799 2017-05-25T06:56:08Z Re: Subtracting in Set Analysis!! https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335227#M835578 <HTML><HEAD></HEAD><BODY><P>The expression seems ok to me. Could you be more specific on your issue?</P></BODY></HTML> Thu, 25 May 2017 07:15:32 GMT https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335227#M835578 2017-05-25T07:15:32Z Re: Subtracting in Set Analysis!! https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335228#M835579 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I get the desired result.Thanks</P></BODY></HTML> Thu, 25 May 2017 07:30:06 GMT https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335228#M835579 Anonymous 2017-05-25T07:30:06Z Re: Subtracting in Set Analysis!! https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335229#M835580 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Perhaps your data in field [Quality] does not have the values 'Timber' or 'Pulp' that you use in Set Analysis expression? Then one term of expression has the value NULL and addition with NULL yields the result NULL.</P><P>And rightly, what is Max one selection ('Timber') you compare with the Min of another selection ('Pulp')?</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Thu, 25 May 2017 07:51:43 GMT https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335229#M835580 ahaahaaha 2017-05-25T07:51:43Z Re: Subtracting in Set Analysis!! https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335230#M835581 <HTML><HEAD></HEAD><BODY><P>Good, Close this thread</P></BODY></HTML> Thu, 25 May 2017 08:29:25 GMT https://community.qlik.com/t5/QlikView/Subtracting-in-Set-Analysis/m-p/1335230#M835581 Anil_Babu_Samineni 2017-05-25T08:29:25Z