topic Re: How to sort a hierarchy? in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-a-hierarchy/m-p/1183903#M383284 <HTML><HEAD></HEAD><BODY><P>Maybe have a look at</P><P><A href="https://community.qlik.com/qlik-blogpost/4325">Bill of Materials</A></P></BODY></HTML> Wed, 14 Sep 2016 16:09:26 GMT swuehl 2016-09-14T16:09:26Z How to sort a hierarchy? https://community.qlik.com/t5/QlikView/How-to-sort-a-hierarchy/m-p/1183902#M383283 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've some problems with my hierarchy table and hope you could help... I'll give you a quick example:</P><P></P><P>I've got a bom wich looks like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Main</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sub1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sub2</STRONG></TH></TR><TR><TD style="padding: 2px;">MainPart</TD><TD style="padding: 2px;">a</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">b</TD><TD style="padding: 2px;">z</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">x</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">c</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">b</TD><TD style="padding: 2px;">z</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">x</TD></TR></TBODY></TABLE><P></P><P>So I'm using the HierarchyBelongsTo Function and get something like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><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">Part</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Depth</STRONG></TH></TR><TR><TD style="padding: 2px;">MainPart</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">MainPart</SPAN></TD><TD style="padding: 2px;">a</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">MainPart</SPAN></TD><TD style="padding: 2px;">b</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">MainPart</SPAN></TD><TD style="padding: 2px;">b</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">MainPart</SPAN></TD><TD style="padding: 2px;">x</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">MainPart</SPAN></TD><TD style="padding: 2px;">x</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">MainPart</SPAN></TD><TD style="padding: 2px;">z</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">MainPart</SPAN></TD><TD style="padding: 2px;">z</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE><P></P><P>How is it possible to achieve a hierarchy wich actually showes how the bom is structured?</P></BODY></HTML> Wed, 14 Sep 2016 09:57:25 GMT https://community.qlik.com/t5/QlikView/How-to-sort-a-hierarchy/m-p/1183902#M383283 2016-09-14T09:57:25Z Re: How to sort a hierarchy? https://community.qlik.com/t5/QlikView/How-to-sort-a-hierarchy/m-p/1183903#M383284 <HTML><HEAD></HEAD><BODY><P>Maybe have a look at</P><P><A href="https://community.qlik.com/qlik-blogpost/4325">Bill of Materials</A></P></BODY></HTML> Wed, 14 Sep 2016 16:09:26 GMT https://community.qlik.com/t5/QlikView/How-to-sort-a-hierarchy/m-p/1183903#M383284 swuehl 2016-09-14T16:09:26Z