Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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.