I have another question regarding the wonderful world of Hierarchies...! I have used the QlikView function HierarchyBelongsTo to create my structure, this is used to create our Bill of Materials. Within this data structure I have Parent, Comp and Qty. My structure may vary from being one level (A Parent and a set of Components), or mutli-level, where a Component may have many sub components, etc.
What I need to do, is compound my Qty figure, but not sure how... I think I need to do this when the data is loaded in the script. i.e.
DQ9500FW is the parent. Comp1 needs 10 to go into DQ9500FW Comp1.2 needs 25 to go into Comp1, so I need to perform the calculation on this component for Comp1.2Qty (25) x Comp1Qty (10).
I need to do this to each component working from the bottom of the structure to the top, until there's the product no longer has a parent...
I hope this makes sense! And I hope you can help me with my query. If you need a data structure then please let me know.
