Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
RajeevaM061
Contributor II
Contributor II

Replicate the Select Exclude in the set analysis

I would like to show the number of customers associated with products which are not selected in the filter. I tied to use the e() in set analysis , unfortunately, it's not working. Kindly help if you have any idea to resolve it. 

Products Customers Group 
Prd1 Cust1
Prd1 Cust2
Prd2 Cust3
Prd3 Cust4

 

For instance, I have selected the Prd1 is selected in the products filters & would like to show the count of customers which are not associated with Prd1. 

I tried the below logic, but it's not working. I'm getting 4 , instead of 2 . Kindly help "

Count ( {<[Products] = e([Products] )>}Distinct [Customers Group]) 

 

1 Reply
marcus_sommer

In general it should work. Make sure that you applies the right field with the correct spelling (Qlik is case-sensitive) because a non-exists field will be ignored.