Customer on only one categorie

[#1]

Hi,

How to count customers who buy a product A and not product B with set analysis ?

count({<Product={"ProductA"}>} CUSTOMERS) = ?

thanks!

[#2]

sorry I want to say, Customer who buy only Product A and never Product B

[jagan]

Hi,

Try this

=Count( {<Product={‘ProductA’}, CUSTOMERS= E({1<Product={‘ProductB’}>})>} CUSTOMERS)

From qlikview help file

sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales )
returns the sales for current selection, but only those customers that never bought the product ‘Shoe’. The element function E( ) here returns the list of excluded customers; those that are excluded by the selection ‘Shoe’ in the field Product.

Hope this helps you.

Regards,

Jagan.