Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
RajeevaM061
Contributor II
Contributor II

Replicate the Select Exclude in the Set Analysis ( Exclude the value selected in the filter)

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]) 

Labels (2)
2 Replies
rubenmarin

Hi, have you tried with 1-$ in set analysis?: Count ({1-$} Distinct [Customers Group]) 

anat
Master
Master

anat_0-1693144178269.png

as per your logic getting 2 when select Prd1