topic Set Analysis Multiple Excludes - Pls Help! in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Multiple-Excludes-Pls-Help/m-p/184727#M49484 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P>I have 3 expressions in a table with multiple exclusions like:</P><P></P><P>=</P><P>sum({$&lt;[Summary L2] -= {'Overtime'},[Summary L1] -= {'Doctors Overtime'},[9CCC - Level 9 Cost Centre Code] -= {'11912','90000'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])</P><BR /><BR /> <P></P><P>=</P><P>sum({$&lt;[Summary L2] -= {'Overtime'},[Summary L1] -= {'Doctors Overtime'},[9CCC - Level 9 Cost Centre Code] = {'11912'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])</P><P></P><P>=</P><P>sum({$&lt;[Summary L2] = {'Overtime'},[9CCC - Level 9 Cost Centre Code] -= {'90000'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])+sum({$&lt;[Summary L1] = {'Doctors Overtime'},[9CCC - Level 9 Cost Centre Code] -= {'90000'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])</P><P>These give me results but the result of this:</P><P></P><P>=</P><P>sum({$&lt;[9CCC - Level 9 Cost Centre Code] -= {'90000'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])</P><P>should equal the sum of the other 3 but doesn't?? Please can anyone correct my syntax?</P><P>Thanks!</P><BR /><BR /> <BR /><BR /> <BR /><BR /></BODY></HTML> Fri, 11 Dec 2009 20:52:41 GMT 2009-12-11T20:52:41Z Set Analysis Multiple Excludes - Pls Help! https://community.qlik.com/t5/QlikView/Set-Analysis-Multiple-Excludes-Pls-Help/m-p/184727#M49484 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P>I have 3 expressions in a table with multiple exclusions like:</P><P></P><P>=</P><P>sum({$&lt;[Summary L2] -= {'Overtime'},[Summary L1] -= {'Doctors Overtime'},[9CCC - Level 9 Cost Centre Code] -= {'11912','90000'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])</P><BR /><BR /> <P></P><P>=</P><P>sum({$&lt;[Summary L2] -= {'Overtime'},[Summary L1] -= {'Doctors Overtime'},[9CCC - Level 9 Cost Centre Code] = {'11912'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])</P><P></P><P>=</P><P>sum({$&lt;[Summary L2] = {'Overtime'},[9CCC - Level 9 Cost Centre Code] -= {'90000'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])+sum({$&lt;[Summary L1] = {'Doctors Overtime'},[9CCC - Level 9 Cost Centre Code] -= {'90000'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])</P><P>These give me results but the result of this:</P><P></P><P>=</P><P>sum({$&lt;[9CCC - Level 9 Cost Centre Code] -= {'90000'}&gt;} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])</P><P>should equal the sum of the other 3 but doesn't?? Please can anyone correct my syntax?</P><P>Thanks!</P><BR /><BR /> <BR /><BR /> <BR /><BR /></BODY></HTML> Fri, 11 Dec 2009 20:52:41 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Multiple-Excludes-Pls-Help/m-p/184727#M49484 2009-12-11T20:52:41Z