topic how do i script this simpy hierarchy in QlikView

topic how do i script this simpy hierarchy in QlikView https://community.qlik.com/t5/QlikView/how-do-i-script-this-simpy-hierarchy/m-p/334671#M123362 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" height="150" style="width: 558px; height: 139px;" width="558"><TBODY><TR><TD class="xl63" height="12" width="180">Material  Name</TD><TD class="xl63" style="border-left-style: none;" width="127">Material Code</TD><TD class="xl63" style="border-left-style: none;" width="114">Component Code</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 1  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">91019PC0</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101900</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 2  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101900</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002001900</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 2  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101900</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002001900</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002101900</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002001900</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">MU0001</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">91667JL0</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002001800</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009106700</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000050049000</TD></TR></TBODY></TABLE><P></P><P>i don't have the component name</P><P></P><P class="p1"><SPAN class="s1">Hierarchy</SPAN><SPAN class="s2"> (</SPAN>COMPONENT_CODE<SPAN class="s2">,</SPAN>MATERIAL_CODE<SPAN class="s2">,</SPAN>??)</P></BODY></HTML> Sat, 02 Jun 2012 23:10:28 GMT amien 2012-06-02T23:10:28Z how do i script this simpy hierarchy https://community.qlik.com/t5/QlikView/how-do-i-script-this-simpy-hierarchy/m-p/334671#M123362 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" height="150" style="width: 558px; height: 139px;" width="558"><TBODY><TR><TD class="xl63" height="12" width="180">Material  Name</TD><TD class="xl63" style="border-left-style: none;" width="127">Material Code</TD><TD class="xl63" style="border-left-style: none;" width="114">Component Code</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 1  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">91019PC0</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101900</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 2  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101900</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002001900</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 2  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101900</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002001900</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002101900</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002001900</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">MU0001</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">91667JL0</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000002001800</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009106700</TD></TR><TR><TD class="xl64" height="12" style="border-top-style: none;">Level 3  Material</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000009101911</TD><TD class="xl64" style="border-top-style: none; border-left-style: none;">000000000050049000</TD></TR></TBODY></TABLE><P></P><P>i don't have the component name</P><P></P><P class="p1"><SPAN class="s1">Hierarchy</SPAN><SPAN class="s2"> (</SPAN>COMPONENT_CODE<SPAN class="s2">,</SPAN>MATERIAL_CODE<SPAN class="s2">,</SPAN>??)</P></BODY></HTML> Sat, 02 Jun 2012 23:10:28 GMT https://community.qlik.com/t5/QlikView/how-do-i-script-this-simpy-hierarchy/m-p/334671#M123362 amien 2012-06-02T23:10:28Z how do i script this simpy hierarchy https://community.qlik.com/t5/QlikView/how-do-i-script-this-simpy-hierarchy/m-p/334672#M123363 <HTML><HEAD></HEAD><BODY><P>Hi Amien,</P><P></P><P>try my suggestion:</P><P>Hierarchy (Component_Code, Material_Code, Component_Name)</P><P>LOAD</P><P>    *,</P><P>    Component_Code AS Component_Name</P><P>From . . . </P><P></P><P>Regards</P><P>Roland</P></BODY></HTML> Mon, 04 Jun 2012 14:04:38 GMT https://community.qlik.com/t5/QlikView/how-do-i-script-this-simpy-hierarchy/m-p/334672#M123363 2012-06-04T14:04:38Z