https://community.qlik.com/t5/QlikView/Excluding-filed-values-in-set-expression/m-p/1610610#M735942 <P>=sum({&lt;BRANCH={"*IND*","*AHME*"}&gt;}NETWT)</P><P>&nbsp;</P><P>Under BRANCH field there are up o 20 field names,out of 20 i need to exclude a filed name called PNL, (for eg: PNL is a field name )<BR /><BR />Can anyone tell me how to do this?</P> Wed, 25 Nov 2020 16:16:04 GMT venkat1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Excluding-filed-values-in-set-expression/m-p/1610610#M735942 <P>=sum({&lt;BRANCH={"*IND*","*AHME*"}&gt;}NETWT)</P><P>&nbsp;</P><P>Under BRANCH field there are up o 20 field names,out of 20 i need to exclude a filed name called PNL, (for eg: PNL is a field name )<BR /><BR />Can anyone tell me how to do this?</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Excluding-filed-values-in-set-expression/m-p/1610610#M735942 venkat1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Excluding-filed-values-in-set-expression/m-p/1610613#M735943 <P>=sum({&lt;BRANCH-={"PNL"}&gt;}NETWT)</P> Thu, 08 Aug 2019 10:36:37 GMT https://community.qlik.com/t5/QlikView/Excluding-filed-values-in-set-expression/m-p/1610613#M735943 Frank_Hartmann 2019-08-08T10:36:37Z https://community.qlik.com/t5/QlikView/Excluding-filed-values-in-set-expression/m-p/1617069#M735944 <P>Venkat, I just wanted to follow-up with another link in the Design Blog that may be of some future help, there are other links in that post as well that may be useful too...</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704</A></P> <P>Regards,<BR />Brett</P> Tue, 27 Aug 2019 12:43:18 GMT https://community.qlik.com/t5/QlikView/Excluding-filed-values-in-set-expression/m-p/1617069#M735944 Brett_Bleess 2019-08-27T12:43:18Z