topic Re: creating flat table BOM in QlikView https://community.qlik.com/t5/QlikView/creating-flat-table-BOM/m-p/1068240#M357036 <HTML><HEAD></HEAD><BODY><P>See: <A href="https://community.qlik.com/qlik-blogpost/4325">Bill of Materials</A></P><P></P><P>- Marcus</P></BODY></HTML> Thu, 03 Mar 2016 11:25:21 GMT marcus_sommer 2016-03-03T11:25:21Z creating flat table BOM https://community.qlik.com/t5/QlikView/creating-flat-table-BOM/m-p/1068238#M357034 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">HI,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I'm attempting to perform a bill of materials explosion in QV using Hierarchy &amp; HierarchyBelongsTo. My data looks something like this:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;" width="256"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;" width="64">Parent</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;" width="64">Child</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;" width="64">Type</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;" width="64">Qty</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">B</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">E</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">F</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">B</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">C</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">C</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">D</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">D</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">G</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">G</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">H</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">My goal it to get a <SPAN style="text-decoration: underline;"><STRONG>flat</STRONG></SPAN> table depicting the total BOM structure. The resulting table would look something like this:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;" width="320"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;" width="64">Parent</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;" width="64">Child</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;" width="64">Type</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;" width="64">Qty</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;" width="64">Level</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">0</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">B</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">2</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">C</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">4</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">D</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">8</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">3</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">E</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">F</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">B</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">B</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">0</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">B</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">C</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">2</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">B</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">D</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">4</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">D</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">D</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">0</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">D</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">G</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">D</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">H</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">G</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">G</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Make</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">0</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">G</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">H</TD><TD style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">Buy</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: #ece9d8; font-style: inherit; font-family: inherit;">1</TD></TR></TBODY></TABLE><P></P><P>Any idea? </P></BODY></HTML> Wed, 02 Mar 2016 10:21:20 GMT https://community.qlik.com/t5/QlikView/creating-flat-table-BOM/m-p/1068238#M357034 Anonymous 2016-03-02T10:21:20Z Re: creating flat table BOM https://community.qlik.com/t5/QlikView/creating-flat-table-BOM/m-p/1068239#M357035 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please go through the following link,</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2588">Qlik Design Blog </A></P><P></P><P>BR,</P><P>SK</P></BODY></HTML> Thu, 03 Mar 2016 11:11:13 GMT https://community.qlik.com/t5/QlikView/creating-flat-table-BOM/m-p/1068239#M357035 santhosh_k_n 2016-03-03T11:11:13Z Re: creating flat table BOM https://community.qlik.com/t5/QlikView/creating-flat-table-BOM/m-p/1068240#M357036 <HTML><HEAD></HEAD><BODY><P>See: <A href="https://community.qlik.com/qlik-blogpost/4325">Bill of Materials</A></P><P></P><P>- Marcus</P></BODY></HTML> Thu, 03 Mar 2016 11:25:21 GMT https://community.qlik.com/t5/QlikView/creating-flat-table-BOM/m-p/1068240#M357036 marcus_sommer 2016-03-03T11:25:21Z