topic Exclude in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Exclude-in-Set-Analysis/m-p/365276#M574800 <HTML><HEAD></HEAD><BODY><P> Worked. Thanks</P></BODY></HTML> Wed, 23 May 2012 11:36:55 GMT 2012-05-23T11:36:55Z Exclude in Set Analysis https://community.qlik.com/t5/QlikView/Exclude-in-Set-Analysis/m-p/365274#M574798 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to exclude specific GL Codes from Invoice Amount.</P><P>For e.g.</P><P>sum({$&lt;[GL Code]=E({'ABC',XYZ'})&gt;}[Invoice Amount])</P><P></P><P>Any idea how I can achieve this?</P></BODY></HTML> Wed, 23 May 2012 11:28:57 GMT https://community.qlik.com/t5/QlikView/Exclude-in-Set-Analysis/m-p/365274#M574798 2012-05-23T11:28:57Z Exclude in Set Analysis https://community.qlik.com/t5/QlikView/Exclude-in-Set-Analysis/m-p/365275#M574799 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=sum({$&lt;[GL Code] -= {'ABC',XYZ'} &gt;}[Invoice Amount])</P><P></P><P>and ignore the bug in the expression editor highlighting the minus equal as error.</P></BODY></HTML> Wed, 23 May 2012 11:30:48 GMT https://community.qlik.com/t5/QlikView/Exclude-in-Set-Analysis/m-p/365275#M574799 swuehl 2012-05-23T11:30:48Z Exclude in Set Analysis https://community.qlik.com/t5/QlikView/Exclude-in-Set-Analysis/m-p/365276#M574800 <HTML><HEAD></HEAD><BODY><P> Worked. Thanks</P></BODY></HTML> Wed, 23 May 2012 11:36:55 GMT https://community.qlik.com/t5/QlikView/Exclude-in-Set-Analysis/m-p/365276#M574800 2012-05-23T11:36:55Z