Excluding filed values in set expression

[venkat1]

=sum({<BRANCH={"*IND*","*AHME*"}>}NETWT)

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 )

Can anyone tell me how to do this?

[Frank_Hartmann · Accepted solution]

=sum({<BRANCH-={"PNL"}>}NETWT)

[Brett_Bleess]

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...

https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704

Regards,
Brett