Product Type "is one of"

[mattbrain]

Hi. Have been using Qlikview for about 3 months, and am now stuck.

I have details on items sold as example below:

Customer Name	Product Type	Product Name	Quantity
Rod	Plastic	A	1
Rod	Metal	B	5
Rod	Glass	C	3
Jane	Plastic	A	1
Jane	Glass	C	6
Freddy	Metal	B	3
Freddy	Glass	C	2

I am looking to product a list of customers who have ordered certain products, but not other products.

Would look something like:

Has Ordered Product Type…	(Drop down selection)
Not Ordered Product Type…	(Drop down selection)

So I could say:'

'Has Ordered' = Plastic 'Not Ordered' = Metal This would display Jane

'Has Ordered' = Metal 'Not Ordered' = Plastic This would display Freddy

Any advise on how I could achieve this would be greatly appreciated.

Thanks

[#2]

The following link includes a technical brief that will explain how you can incorporate this functionality:

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

Using your example data, script might look something like this...

Orders:

LOAD * INLINE [
CustomerName, ProductType, ProductName, Quantity
Rod, Plastic, A, 1
Rod, Metal, B, 5
Rod, Glass, C, 3
Jane, Plastic, A, 1
Jane, Glass, C, 6
Freddy, Metal, B, 3
Freddy, Glass, C, 2
];

ANDModeTable:
LOAD Distinct
CustomerName,
ProductType as [ProductType ANDMode]
Resident Orders;

Best of Luck!

[#3]

See attached qvw for an example of what gwen is talking about.

[maxgro]

a different  idea

[mattbrain]

Thanks everyone for your help. Will look at this now.

Thanks again