topic Re: Customer on only one categorie in QlikView

Customer on only one categorie

Wed, 23 Jan 2013 15:32:55 GMT

Hi,

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

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

thanks!

Re: Customer on only one categorie

Wed, 23 Jan 2013 15:37:46 GMT

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

Re: Customer on only one categorie

jagan — Wed, 23 Jan 2013 15:42:01 GMT

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.