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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude by selected field(s)

Hi

I hope someone can help with should be a simple problem to overcome:

I am building a Qlikview 9 app to generate a list of customers based the selection of various customer attributes. I have an associated table linked to the main table by customerID that contains products these customers have bought. In my final list I want to include all customers that have not bought particular product(s), which will include customers who have never bought any products.

The problem is if I pick the product from my list box and choose exclude selected, the other products are selected, which filters on just the customers that have bought one of the other products, excluding any customers that have never bought any products.

Any ideas?

Thanks



0 Replies