topic Re: Show all Customer's that didn't bought specific product in QlikView

Show all Customer's that didn't bought specific product

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to present a list that contain customer names of all customers that didn't bought specific product.

for example:

Customer_Name	Product_1	Product_2	Product_2
Name_1	1	-	0
Name_2	1	1	1
Name_3	-	-	1

I want to have a list box that contains all the available products and by selecting one product in the list box I will get list/table of all the customers that didn't bought the selected product.

so if I select product_2 I will get Customers: Name_1 and Name_2.

I tried to use the e(Product_Name) function but it didn't work for me because once the customer bought different product and didn't bought the selected one he appears in the chart.

Any idea how I can deal with this issue?

Thanks a lot

Re: Show all Customer's that didn't bought specific product

Gysbert_Wassenaar — Thu, 19 Oct 2017 16:19:43 GMT

Assuming you have one field named Product_Name and not three fields named Product_1, Product_2 and Product_3...

Create a straight table with Customer_Name as dimension and this expression: sum({<Product_Name=,Customer_Name=E({<Product_Name=P(Product_Name)>}Customer_Name)>}1)

Re: Show all Customer's that didn't bought specific product

Anonymous — Sun, 22 Oct 2017 06:56:34 GMT

Hi gwassenaar‌

Thank you it's work perfect!