topic Excluding fields in set analysis in QlikView https://community.qlik.com/t5/QlikView/Excluding-fields-in-set-analysis/m-p/136592#M754183 <HTML><HEAD></HEAD><BODY><P>I have some warehouses and want to exclude 3 of them from my output, this is the formula I tried and it doesn't work</P><P></P><P>count({&lt;trans_act= {'SHIP'},trans_obj={'OBO'},facility={'C'},<STRONG>whse -= {'CHIC','FCNC','CLMU'</STRONG>}&gt;}lno)</P><P></P><P>I want to exclude CHIC, FCNC, and CLMU how do I do this?</P><P></P><P>Thanks,</P><P>Josh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT jmcdermott 2020-11-25T16:16:04Z Excluding fields in set analysis https://community.qlik.com/t5/QlikView/Excluding-fields-in-set-analysis/m-p/136592#M754183 <HTML><HEAD></HEAD><BODY><P>I have some warehouses and want to exclude 3 of them from my output, this is the formula I tried and it doesn't work</P><P></P><P>count({&lt;trans_act= {'SHIP'},trans_obj={'OBO'},facility={'C'},<STRONG>whse -= {'CHIC','FCNC','CLMU'</STRONG>}&gt;}lno)</P><P></P><P>I want to exclude CHIC, FCNC, and CLMU how do I do this?</P><P></P><P>Thanks,</P><P>Josh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Excluding-fields-in-set-analysis/m-p/136592#M754183 jmcdermott 2020-11-25T16:16:04Z Re: Excluding fields in set analysis https://community.qlik.com/t5/QlikView/Excluding-fields-in-set-analysis/m-p/136593#M754184 <HTML><HEAD></HEAD><BODY><P>Never mind the formula does work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Thu, 04 Oct 2018 18:33:38 GMT https://community.qlik.com/t5/QlikView/Excluding-fields-in-set-analysis/m-p/136593#M754184 jmcdermott 2018-10-04T18:33:38Z Re: Excluding fields in set analysis https://community.qlik.com/t5/QlikView/Excluding-fields-in-set-analysis/m-p/136594#M754185 <HTML><HEAD></HEAD><BODY><P>Another option</P><P></P><P><STRONG>Count({&lt;trans_act = {'SHIP'}, trans_obj = {'OBO'},facility={'C'}, <SPAN style="color: #ff0000;">whse = e({&lt;whse = {'CHIC','FCNC','CLMU'}&gt;})</SPAN>&gt;} lno)</STRONG></P></BODY></HTML> Thu, 04 Oct 2018 18:46:54 GMT https://community.qlik.com/t5/QlikView/Excluding-fields-in-set-analysis/m-p/136594#M754185 sunny_talwar 2018-10-04T18:46:54Z