topic Re: Bill of Materials from Navision in QlikView https://community.qlik.com/t5/QlikView/Bill-of-Materials-from-Navision/m-p/414792#M700754 <HTML><HEAD></HEAD><BODY><P>BOM:</P><P>Hierarchy("No_","Production BOM No_","Description",,"No_", TreeView) Load</P><P>&nbsp;&nbsp;&nbsp; "No_",</P><P>&nbsp;&nbsp;&nbsp; Type,</P><P>&nbsp;&nbsp;&nbsp; "Production BOM No_",</P><P>&nbsp;&nbsp;&nbsp; "Description",</P><P>&nbsp;&nbsp;&nbsp; Quantity;</P><P>SQL SELECT *</P><P>FROM "Production BOM Line"</P><P>where "Type" &lt;&gt; '';</P></BODY></HTML> Fri, 09 Nov 2012 12:08:29 GMT salto 2012-11-09T12:08:29Z Bill of Materials from Navision https://community.qlik.com/t5/QlikView/Bill-of-Materials-from-Navision/m-p/414790#M700752 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have been looking for a way to make a explosion of the Production_BOM_Line table.</P><P>Every Item with a BOM (Bill of Materials) has a BOM No. in this table, which has these relevant fields:</P><P></P><P>BOM No.&nbsp;&nbsp;&nbsp;&nbsp; Line No.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item/ProdBOM No.&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>BOM1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item1</P><P>BOM1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item2</P><P>BOM1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BOM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BOM2</P><P></P><P>BOM2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item1</P><P>BOM2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item2</P><P>BOM2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item3</P><P></P><P>Item1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item4</P><P>Item1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BOM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BOM3</P><TABLE><TBODY><TR><TD><BR /></TD></TR></TBODY></TABLE><P>BOM3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item5</P><P>BOM3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item6</P><P></P><P>So, BOM1 is a Bill of Materials which has three components / lines: two Items (Item1 and Item2) and a BOM (BOM2). This BOM2 consists on three items (Item1, Item2 and Item3). Item1 consists on another Item (Item4) and a BOM (BOM3).</P><P></P><P>I would like to make a explosion of this BOM table like a tree. Can the hierarchy function help on this?</P><P>I would really appreciate any recommendation on how to attack this issue.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 08 Nov 2012 08:50:50 GMT https://community.qlik.com/t5/QlikView/Bill-of-Materials-from-Navision/m-p/414790#M700752 salto 2012-11-08T08:50:50Z Re: Bill of Materials from Navision https://community.qlik.com/t5/QlikView/Bill-of-Materials-from-Navision/m-p/414791#M700753 <HTML><HEAD></HEAD><BODY><P>Hi salto</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes.... hierarchy shud work fine....</P><P></P><P>regards,</P><P> vaibhav</P></BODY></HTML> Thu, 08 Nov 2012 09:27:21 GMT https://community.qlik.com/t5/QlikView/Bill-of-Materials-from-Navision/m-p/414791#M700753 Anonymous 2012-11-08T09:27:21Z Re: Bill of Materials from Navision https://community.qlik.com/t5/QlikView/Bill-of-Materials-from-Navision/m-p/414792#M700754 <HTML><HEAD></HEAD><BODY><P>BOM:</P><P>Hierarchy("No_","Production BOM No_","Description",,"No_", TreeView) Load</P><P>&nbsp;&nbsp;&nbsp; "No_",</P><P>&nbsp;&nbsp;&nbsp; Type,</P><P>&nbsp;&nbsp;&nbsp; "Production BOM No_",</P><P>&nbsp;&nbsp;&nbsp; "Description",</P><P>&nbsp;&nbsp;&nbsp; Quantity;</P><P>SQL SELECT *</P><P>FROM "Production BOM Line"</P><P>where "Type" &lt;&gt; '';</P></BODY></HTML> Fri, 09 Nov 2012 12:08:29 GMT https://community.qlik.com/t5/QlikView/Bill-of-Materials-from-Navision/m-p/414792#M700754 salto 2012-11-09T12:08:29Z