Exclude values in listbox

[tom2013]

Hi all,

I wonder if there's a way to select the values in a field that belongs exclusively to a value in another field by using list box.

A simple example to make it clear:

From the table below I would like to filter out all the products that have only been ordered by customer B, and not by A.

So if I select value A and B in Customer field first, can I exclude all the products that has been ordered by A (001-003), so only product ordered by B (004) will be selected.

Thank you in advance.

Customer  Product

A             001

A             002

A             003

B             003

B             004

[ashok_rajm]

Do you want to exclude in backend or in front end.. Can you specify more details and what results you are looking for..

[tom2013]

Thank you for your reply, I have updated the question description. I want to know if this could be done in front end by using list box, so I can get the desired data range for my chart.

[ashok_rajm]

Incase if you have Customer A,B,C and if you select A, B & C together. what results you would need.

[tom2013]

I would like to filter out all the products that have been ordered only by Customer B, not anyone else.

[ashok_rajm]

So what i understood is, if you Select A & B, You need only Product 4 to be shown in the Product list box as 4 is the only Unique Product from B.

[tom2013]

Yes exactly

[ashok_rajm · Accepted solution]

Ok.. I think you con't directly achieve this in Front end, because there is no any key which says this unique value. 

I was able to create it with back-end and front-end.

Listbox expression: = if(GetSelectedCount(Customer)>0,if(WildMatch(Customer, '*B*') and Key <> 1 ,Product),Product)

And back-end you need to create a flag for each unique values for B:

TT:
LOAD * INLINE [
Customer, Product
A, 1
A, 2
A, 3
B, 3
B, 4
B, 5
];

Load Product,1 as Key Resident TT where Customer = 'A';

Hope This Helps.

[tom2013]

Hi Ashok, 

Thank you so much for the detailed answer!