https://community.qlik.com/t5/App-Development/Sum-using-Multiple-conditions/m-p/1801693#M65014 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/136973">@Arvind_07</a>&nbsp;</P><P>Try like below</P><P><SPAN>sum({&lt;Date={'$(=date(WeekStart(Today()-7)))'}<STRONG>, [Product Category]-={'A Box', 'B Box', 'C Box'}</STRONG>&gt;}[DOM.MTD Sales Units])</SPAN></P> Thu, 22 Apr 2021 10:57:42 GMT MayilVahanan 2021-04-22T10:57:42Z https://community.qlik.com/t5/App-Development/Sum-using-Multiple-conditions/m-p/1801689#M65013 <P>Hello,</P><P>Im new to Qlik sense and started learning about set analysis. In the below expression, is it possible to pass another condition like to exclude certain values from a field within the below set analysis expression.</P><P>sum({&lt;Date={'$(=date(WeekStart(Today()-7)))'}&gt;}[DOM.MTD Sales Units])</P><P>My Field- Product Category</P><P>To exclude field values- 'A Box', 'B Box', 'C Box'</P><P>could someone advise me on this</P><P>Thanks much</P> Tue, 21 Dec 2021 21:56:36 GMT https://community.qlik.com/t5/App-Development/Sum-using-Multiple-conditions/m-p/1801689#M65013 Arvind_07 2021-12-21T21:56:36Z https://community.qlik.com/t5/App-Development/Sum-using-Multiple-conditions/m-p/1801693#M65014 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/136973">@Arvind_07</a>&nbsp;</P><P>Try like below</P><P><SPAN>sum({&lt;Date={'$(=date(WeekStart(Today()-7)))'}<STRONG>, [Product Category]-={'A Box', 'B Box', 'C Box'}</STRONG>&gt;}[DOM.MTD Sales Units])</SPAN></P> Thu, 22 Apr 2021 10:57:42 GMT https://community.qlik.com/t5/App-Development/Sum-using-Multiple-conditions/m-p/1801693#M65014 MayilVahanan 2021-04-22T10:57:42Z