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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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