topic A Hierarchy Question... For a change!! in QlikView https://community.qlik.com/t5/QlikView/A-Hierarchy-Question-For-a-change/m-p/220529#M73438 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>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.</P><P>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.</P><P>DQ9500FW is the parent.<BR />Comp1 needs 10 to go into DQ9500FW<BR />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).</P><P>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...</P><P>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.</P><P>Kind Regards,<BR />Dayna</P></BODY></HTML> Thu, 17 Feb 2011 17:02:39 GMT Dayna 2011-02-17T17:02:39Z A Hierarchy Question... For a change!! https://community.qlik.com/t5/QlikView/A-Hierarchy-Question-For-a-change/m-p/220529#M73438 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>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.</P><P>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.</P><P>DQ9500FW is the parent.<BR />Comp1 needs 10 to go into DQ9500FW<BR />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).</P><P>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...</P><P>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.</P><P>Kind Regards,<BR />Dayna</P></BODY></HTML> Thu, 17 Feb 2011 17:02:39 GMT https://community.qlik.com/t5/QlikView/A-Hierarchy-Question-For-a-change/m-p/220529#M73438 Dayna 2011-02-17T17:02:39Z