Discussion Board for collaboration on QlikView Scripting.
I need help linking my Item Hierarchy. In the example below we buy cases of drinks and either sell the cases or break them up and sell the individual bottles.
They are linked in the Item table where the bottle has a ParentID which is the actually the ItemID of the parent item.
Looking for way to link them so I can see sales converted in the same method we purchase them which is cases.
Currently when I sum sales and quantity this is the layout
Ideally this is the layout I would like and I would convert the child item quantites and link them to the parent items