List of Product Lines which were never bought (by customer)

[#1]

Hello Guys! Newbie here posting his first question.

I'm sorry if it's duplicated, I swear I have searched for it in a few ways, but being a non-native english speaker, maybe I used the wrong keywords and found no results. So here we go!

I have a list of product lines.

There is also a list of customers, which have bough some, none or all product lines.

I was able to list every product line bought by each customer, but I want the opposite:

Column 1 - Customer Number

Column 2 - A Concatenation of every product line which has never been acquired by this Customer Number

Any ideas on how to achieve this?

Thanks in advance!

Helvio

[#2]

Yes, you can use a set analysis using -E parameter to get all excluded values

for ex

sum({<customer = -E {'customer'}  >} sales

will (should)  give customer without sales according current selection

sorry may be the syntax is not very true but it is a long time i haven't done it. Check Set analysis syntax

best regards

Chris

[#3]

This E( ) and P( ) are the ones I'm struggling with

I appreciate your effort, it told me that I'm on the right path. Not yet solved, though...

Would you be so kind to present a correct formula?

I know I'm asking too much, but set analysis is still very confusing to me.

Thank you!

[nikhilgandhi715]

You can also use the Action "Select Excluded" by using a button to display all the product lines which are not associated with the Customer name.

[#5]

Doesn't work, because I would have to do it for each customer. I need to do it for like 4000+

[#6]

Hi

here is some material.

Take time to read it, that will help

best regards

Chris

[#7]

Helvio

this might be useful too

http://community.qlik.com/thread/105714

chris

[ashfaq_haseeb]

Start from here.

http://community.qlik.com/docs/DOC-4708

And look at the wizard in the same post .

Regards

ASHFAQ