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 "
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.
