topic Re: Count customer that only buy one product in QlikView

Count customer that only buy one product

Tue, 11 Nov 2014 20:58:29 GMT

HI. I have a listbox with items that customer have bought. How can I count how many people that have only bought the selected product in following example?And nothing else.

customer. Item

a. Shirt

a. Shoes

b. Shoes

c. Shirt

d. gloves

d. Shoes

e Gloves

expected result.

If I selected Shirt, number of customer = 1 (cust c)

select gloves, number of customer = 1 (cust e)

Re: Count customer that only buy one product

jduenyas — Wed, 12 Nov 2014 00:33:53 GMT

Try

Aggr(Count( Distinct customer), Item)

Re: Count customer that only buy one product

MK_QSL — Wed, 12 Nov 2014 00:40:27 GMT

=COUNT({<Item = P(Item)>}DISTINCT customer)

Re: Count customer that only buy one product

jagan — Wed, 12 Nov 2014 03:52:16 GMT

Hi,

Try like this

Chart : Straight Table

Dimension: Customer

Expression: Sum({<Item =P(Item)>} Aggr(If(Count({<Item =>}DISTINCT Item) = 1, 1, 0), customer))

Hope this helps you.

Regards,

Jagan.

Re: Count customer that only buy one product

anbu1984 — Wed, 12 Nov 2014 04:49:10 GMT

=Count(DISTINCT {<customer=P(customer)>-<customer=P({<Item=E(Item)>})>}customer)