topic Re: Excluding values in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Excluding-values-in-Set-Analysis/m-p/1030884#M348029 <HTML><HEAD></HEAD><BODY><P>Maybe </P><P></P><P>Sum({&lt;E={X}&gt;-&lt;B ={1},C={1}&gt;} D)</P><P></P><P>Note that your two expressions both contain the first record, hence your sum is +1.</P></BODY></HTML> Wed, 27 Apr 2016 13:14:11 GMT swuehl 2016-04-27T13:14:11Z Excluding values in Set Analysis https://community.qlik.com/t5/QlikView/Excluding-values-in-Set-Analysis/m-p/1030883#M348028 <HTML><HEAD></HEAD><BODY><P>I need some help with set analysis.</P><P></P><P>Please exclude the B = 1 and C = 1 if it's possible in one set analysis statement.</P><P><IMG alt="Screenshot_2.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122882_Screenshot_2.jpg" style="height: auto;" /></P><P></P><P>Thank you!</P></BODY></HTML> Wed, 27 Apr 2016 13:08:56 GMT https://community.qlik.com/t5/QlikView/Excluding-values-in-Set-Analysis/m-p/1030883#M348028 MindaugasBacius 2016-04-27T13:08:56Z Re: Excluding values in Set Analysis https://community.qlik.com/t5/QlikView/Excluding-values-in-Set-Analysis/m-p/1030884#M348029 <HTML><HEAD></HEAD><BODY><P>Maybe </P><P></P><P>Sum({&lt;E={X}&gt;-&lt;B ={1},C={1}&gt;} D)</P><P></P><P>Note that your two expressions both contain the first record, hence your sum is +1.</P></BODY></HTML> Wed, 27 Apr 2016 13:14:11 GMT https://community.qlik.com/t5/QlikView/Excluding-values-in-Set-Analysis/m-p/1030884#M348029 swuehl 2016-04-27T13:14:11Z