topic Re: hierarchy - Single table fields linked to another in QlikView https://community.qlik.com/t5/QlikView/hierarchy-Single-table-fields-linked-to-another/m-p/1298155#M404940 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA file for your reference. This may help you.</P></BODY></HTML> Thu, 27 Jul 2017 15:15:50 GMT md_qlikview 2017-07-27T15:15:50Z hierarchy - Single table fields linked to another https://community.qlik.com/t5/QlikView/hierarchy-Single-table-fields-linked-to-another/m-p/1298153#M404938 <HTML><HEAD></HEAD><BODY><P>I have a table like below:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Username</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ReportingID</STRONG></TH></TR><TR><TD style="padding: 2px;">John Abott</TD><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">333</TD></TR><TR><TD style="padding: 2px;">Melissa White</TD><TD style="padding: 2px;">333</TD><TD style="padding: 2px;">234</TD></TR><TR><TD style="padding: 2px;">Tom Bunch</TD><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">533</TD></TR><TR><TD style="padding: 2px;">Elias Wu</TD><TD style="padding: 2px;">533</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Tim May</TD><TD style="padding: 2px;">433</TD><TD style="padding: 2px;">333</TD></TR><TR><TD style="padding: 2px;">Isiah Field</TD><TD style="padding: 2px;">122</TD><TD style="padding: 2px;">333</TD></TR><TR><TD style="padding: 2px;">Mike Berdie</TD><TD style="padding: 2px;">456</TD><TD style="padding: 2px;">234</TD></TR></TBODY></TABLE><P></P><P></P><P>How do i create a hiarchy chart from above table. How can i show reporting structure for each Username.</P><P></P><P>Elisa Wu</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Tom Bunch</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mike Berdie</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Melissa White</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John Abott</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tim May</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Isiah Field</P></BODY></HTML> Wed, 26 Jul 2017 19:26:08 GMT https://community.qlik.com/t5/QlikView/hierarchy-Single-table-fields-linked-to-another/m-p/1298153#M404938 userid128223 2017-07-26T19:26:08Z Re: hierarchy - Single table fields linked to another https://community.qlik.com/t5/QlikView/hierarchy-Single-table-fields-linked-to-another/m-p/1298154#M404939 <HTML><HEAD></HEAD><BODY><P>Anyone with solution?</P></BODY></HTML> Thu, 27 Jul 2017 14:58:27 GMT https://community.qlik.com/t5/QlikView/hierarchy-Single-table-fields-linked-to-another/m-p/1298154#M404939 userid128223 2017-07-27T14:58:27Z Re: hierarchy - Single table fields linked to another https://community.qlik.com/t5/QlikView/hierarchy-Single-table-fields-linked-to-another/m-p/1298155#M404940 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA file for your reference. This may help you.</P></BODY></HTML> Thu, 27 Jul 2017 15:15:50 GMT https://community.qlik.com/t5/QlikView/hierarchy-Single-table-fields-linked-to-another/m-p/1298155#M404940 md_qlikview 2017-07-27T15:15:50Z