Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
davidsaban
Contributor II
Contributor II

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

Hi all,

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

for example:

Customer_NameProduct_1Product_2Product_2
Name_11-0
Name_2111
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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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)


talk is cheap, supply exceeds demand
davidsaban
Contributor II
Contributor II
Author

Hi gwassenaar

Thank you it's work perfect!