1 - I want to display a list of all the items in the company with a flag if the selected customer has bought this item.
When I select a customer Qlikview filters the list of items to the items that the customer purchased; I need to see the items that the customer did not purchased.
2 - My customers are divided into groups based on the type of business (TOB).
I need to generate a list of top 100 selling items by TOB and then to check each customer belonging to this TOB what he purchased and what he did not purchased from the top 100 items of his TOB.