Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mattbrain
New Contributor

Product Type "is one of"

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

I have details on items sold as example below:

Customer NameProduct TypeProduct NameQuantity
RodPlasticA1
RodMetalB5
RodGlassC3
JanePlasticA1
JaneGlassC6
FreddyMetalB3
FreddyGlassC2

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

4 Replies
Highlighted
Not applicable

Re: Product Type "is one of"

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!

Not applicable

Re: Product Type "is one of"

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

MVP
MVP

Re: Product Type "is one of"

a different  idea

mattbrain
New Contributor

Re: Product Type "is one of"

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

Thanks again