Discussion board where members can get started with QlikView.
Hi. Have been using Qlikview for about 3 months, and am now stuck.
I have details on items sold as example below:
I am looking to product a list of customers who have ordered certain products, but not other products.
Would look something like:
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.
The following link includes a technical brief that will explain how you can incorporate this functionality:
Using your example data, script might look something like this...
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 DistinctCustomerName,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.