Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to count customers who buy a product A and not product B with set analysis ?
count({<Product={"ProductA"}>} CUSTOMERS) = ?
thanks!
sorry I want to say, Customer who buy only Product A and never Product B
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.