topic Creating Product hierarchy from a Flat structure table. in QlikView https://community.qlik.com/t5/QlikView/Creating-Product-hierarchy-from-a-Flat-structure-table/m-p/631567#M231763 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table with product codes, and based on the product codes I need to create product hierarchy:</P><P></P><P>The codes are as below:</P><P></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp; Level 1: 10100 – Enamel</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 2: 1010001010 – S H E</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000101010101010 – Whites</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000101010101020 – Colors</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000101010101040 – Tinted Bases</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 2: 1010001020 - SuperLac Satin Finish</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000102010102010 – Whites</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000102010102020 – Colors</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000102010102040 - Tinted Bases </SPAN></P><P><SPAN style="color: #1f497d;"><BR /></SPAN></P><P><SPAN style="color: #1f497d;">and so on.....<BR /></SPAN></P><P><SPAN style="color: #1f497d;"><BR /></SPAN></P><P><SPAN style="color: #1f497d;">All these codes are in the same table and same field but need to be bifurcated&nbsp; based on the code.</SPAN></P><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;">Need need GUYS!!<BR /></SPAN></P></BODY></HTML> Tue, 13 May 2014 13:52:18 GMT alkesh_sharma 2014-05-13T13:52:18Z Creating Product hierarchy from a Flat structure table. https://community.qlik.com/t5/QlikView/Creating-Product-hierarchy-from-a-Flat-structure-table/m-p/631567#M231763 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table with product codes, and based on the product codes I need to create product hierarchy:</P><P></P><P>The codes are as below:</P><P></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp; Level 1: 10100 – Enamel</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 2: 1010001010 – S H E</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000101010101010 – Whites</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000101010101020 – Colors</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000101010101040 – Tinted Bases</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 2: 1010001020 - SuperLac Satin Finish</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000102010102010 – Whites</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000102010102020 – Colors</SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3: 101000102010102040 - Tinted Bases </SPAN></P><P><SPAN style="color: #1f497d;"><BR /></SPAN></P><P><SPAN style="color: #1f497d;">and so on.....<BR /></SPAN></P><P><SPAN style="color: #1f497d;"><BR /></SPAN></P><P><SPAN style="color: #1f497d;">All these codes are in the same table and same field but need to be bifurcated&nbsp; based on the code.</SPAN></P><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;">Need need GUYS!!<BR /></SPAN></P></BODY></HTML> Tue, 13 May 2014 13:52:18 GMT https://community.qlik.com/t5/QlikView/Creating-Product-hierarchy-from-a-Flat-structure-table/m-p/631567#M231763 alkesh_sharma 2014-05-13T13:52:18Z Re: Creating Product hierarchy from a Flat structure table. https://community.qlik.com/t5/QlikView/Creating-Product-hierarchy-from-a-Flat-structure-table/m-p/631568#M231764 <HTML><HEAD></HEAD><BODY><P>External excel with the hirechachy?</P></BODY></HTML> Tue, 13 May 2014 14:25:29 GMT https://community.qlik.com/t5/QlikView/Creating-Product-hierarchy-from-a-Flat-structure-table/m-p/631568#M231764 fkeuroglian 2014-05-13T14:25:29Z