Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Sum using Multiple conditions


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

Labels (2)
1 Reply

Hi @Arvind_07 

Try like below

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.