topic Set Analysis for substraction in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-for-substraction/m-p/1421549#M798543 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>As shown in below image, I need Coding Review count = Coding Review - Coding Count</P><P></P><P>Business logic is , If i am doing coding review for company, Process Doc Type then all documents coded by me will be reviewed by me.</P><P>And these should not be considered in my review count.</P><P></P><P>Attaching the sample Excel and QV file </P><P></P><P></P><P>Thanks </P><P><IMG alt="1.png" class="jive-image image-1" height="313" src="https://community.qlik.com/legacyfs/online/187350_1.png" style="height: 313px; width: 737.871px;" width="738" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Set Analysis for substraction https://community.qlik.com/t5/QlikView/Set-Analysis-for-substraction/m-p/1421549#M798543 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>As shown in below image, I need Coding Review count = Coding Review - Coding Count</P><P></P><P>Business logic is , If i am doing coding review for company, Process Doc Type then all documents coded by me will be reviewed by me.</P><P>And these should not be considered in my review count.</P><P></P><P>Attaching the sample Excel and QV file </P><P></P><P></P><P>Thanks </P><P><IMG alt="1.png" class="jive-image image-1" height="313" src="https://community.qlik.com/legacyfs/online/187350_1.png" style="height: 313px; width: 737.871px;" width="738" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-substraction/m-p/1421549#M798543 Anonymous 2020-11-25T16:16:04Z Re: Set Analysis for substraction https://community.qlik.com/t5/QlikView/Set-Analysis-for-substraction/m-p/1421550#M798545 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=If(ProcessType = 'Coding Review', Sum(NoOfTrans) - Sum(TOTAL &lt;CompanyName, Processor, ProcessDocType&gt;{&lt;ProcessType = {'Coding'}&gt;} NoOfTrans), SUM(NoOfTrans))</STRONG></P></BODY></HTML> Mon, 18 Dec 2017 13:09:36 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-substraction/m-p/1421550#M798545 sunny_talwar 2017-12-18T13:09:36Z Re: Set Analysis for substraction https://community.qlik.com/t5/QlikView/Set-Analysis-for-substraction/m-p/1421551#M798546 <HTML><HEAD></HEAD><BODY><P>Can you make Result set in new column please</P></BODY></HTML> Mon, 18 Dec 2017 13:19:19 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-substraction/m-p/1421551#M798546 Anil_Babu_Samineni 2017-12-18T13:19:19Z Re: Set Analysis for substraction https://community.qlik.com/t5/QlikView/Set-Analysis-for-substraction/m-p/1421552#M798547 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>It worked perfect <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />. Thanks for the solution</P></BODY></HTML> Wed, 20 Dec 2017 06:22:06 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-substraction/m-p/1421552#M798547 Anonymous 2017-12-20T06:22:06Z