Sum using Multiple conditions

[Arvind_07]

Hello,

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.

sum({<Date={'$(=date(WeekStart(Today()-7)))'}>}[DOM.MTD Sales Units])

My Field- Product Category

To exclude field values- 'A Box', 'B Box', 'C Box'

could someone advise me on this

Thanks much

[MayilVahanan]

Hi @Arvind_07 

Try like below

sum({<Date={'$(=date(WeekStart(Today()-7)))'}, [Product Category]-={'A Box', 'B Box', 'C Box'}>}[DOM.MTD Sales Units])