Exclude by selected field(s)

Tue, 01 Dec 2009 20:24:39 GMT

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

topic Exclude by selected field(s) in QlikView

Exclude by selected field(s)