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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show only customers who purchased all selected values (brands)

Hello,

Hope someone can help me. What I want is this: to get a list of customers who purchased all selected Brands. Now, when I select three brands like Bison, Altrex and AXA I get all customers which purchased one or more brands, See below:

BrandCustomer
Total 905
BisonRetail235
BisonPhilips202
BisonOrganised Deal155
BisonNot Organised Deal170
AltrexRetail55
AltrexPhilips35
AltrexDos Pinos25
AXARetail16
AXAPhilips12

What I want to see is this:


BrandCustomer
Total 555
BisonRetail235
BisonPhilips202
AltrexRetail55
AltrexPhilips35
AXARetail16
AXAPhilips12


I think I need to use set analysis, but I just can't figure out how. Thank you in advance.

0 Replies