Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
See attached qvw for an example of what gwen is talking about.
a different idea
Thanks everyone for your help. Will look at this now.
Thanks again