Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Only Count Customer buy selected products

Dear All

I want to count only customer buy selected products

Here my sample dada

CUS_NAMEPRODUCT
JohnA
JohnB
PeterD
KenA
KenC
KenD
TonyA
TonyB
TonyC
MaryB
LisaD

here is result I expected

if i chose PRODUCT = D, the result count customer = 2 (Peter and lisa), because Peter and lisa buy only product 'D' (Ken also buy D product but also bought A and B should not be counted)

if i chose Product =A and B, the result count customer = 1 (John) because John just buy two products A and B (Tony also bought one more product 'D' should not be counted)


I don't know how to do, please help me if possible

regards

An Pham


1 Reply
Not applicable

Re: Only Count Customer buy selected products

Dear All

I found this thread Count customer that only buy one product

It solved my issue

Tks