Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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.

Community Browser