topic Re: Hierarchy / Parents in QlikView https://community.qlik.com/t5/QlikView/Hierarchy-Parents/m-p/438613#M163503 <HTML><HEAD></HEAD><BODY><P>Thanks, but i need result table like the one i sketched...</P></BODY></HTML> Fri, 15 Feb 2013 09:46:13 GMT 2013-02-15T09:46:13Z Hierarchy / Parents https://community.qlik.com/t5/QlikView/Hierarchy-Parents/m-p/438611#M163501 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have a problem with a table that i LOAD and i want to restructure. The source table looks somewhat like follws:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 70%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>LocationID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>LocationName</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ParentLocation</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Depth</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>World</TD><TD><BR /></TD><TD>0</TD></TR><TR><TD>2</TD><TD>Europe</TD><TD>1</TD><TD>1</TD></TR><TR><TD>3</TD><TD>America</TD><TD>1</TD><TD>1</TD></TR><TR><TD>4</TD><TD>Africa</TD><TD>1</TD><TD>1</TD></TR><TR><TD>5</TD><TD>South America</TD><TD>3</TD><TD>2</TD></TR><TR><TD>6</TD><TD>Eastern Europe</TD><TD>2</TD><TD>2</TD></TR><TR><TD>7</TD><TD>Sao Paolo</TD><TD>5</TD><TD>3</TD></TR><TR><TD>8</TD><TD>Moscau</TD><TD>6</TD><TD>3</TD></TR></TBODY></TABLE><P></P><P>What i want is:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 70%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>LocationID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Location</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubLocationID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubLocation</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSubLocationID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSubLocation</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSubSubLocationID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSubSubLocation</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>World</TD><TD>2</TD><TD>Europe</TD><TD>6</TD><TD>Eastern Europe</TD><TD>8</TD><TD>Moscau</TD></TR><TR><TD>1</TD><TD>World</TD><TD>3</TD><TD>America</TD><TD>5</TD><TD>South America</TD><TD>7</TD><TD>Sao Paolo</TD></TR><TR><TD>1</TD><TD>World</TD><TD>4</TD><TD>Africa</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>Can someone help ?</P><P></P><P>Thanks a lot!</P></BODY></HTML> Fri, 15 Feb 2013 09:25:59 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Parents/m-p/438611#M163501 2013-02-15T09:25:59Z Re: Hierarchy / Parents https://community.qlik.com/t5/QlikView/Hierarchy-Parents/m-p/438612#M163502 <HTML><HEAD></HEAD><BODY><P>Here's a simple example using the hierarchy function to create a hierarchy table.</P></BODY></HTML> Fri, 15 Feb 2013 09:35:04 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Parents/m-p/438612#M163502 Gysbert_Wassenaar 2013-02-15T09:35:04Z Re: Hierarchy / Parents https://community.qlik.com/t5/QlikView/Hierarchy-Parents/m-p/438613#M163503 <HTML><HEAD></HEAD><BODY><P>Thanks, but i need result table like the one i sketched...</P></BODY></HTML> Fri, 15 Feb 2013 09:46:13 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Parents/m-p/438613#M163503 2013-02-15T09:46:13Z Re: Hierarchy / Parents https://community.qlik.com/t5/QlikView/Hierarchy-Parents/m-p/438614#M163504 <HTML><HEAD></HEAD><BODY><P>Hi Phillipe,</P><P>You can try using a cross table,you can achieve the format :</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><THEAD><TR><TH align="center" class="header" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>LocationID</STRONG></SPAN></TH><TH align="center" class="header" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Location</STRONG></SPAN></TH><TH align="center" class="header" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubLocationID</STRONG></SPAN></TH><TH align="center" class="header" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubLocation</STRONG></SPAN></TH><TH align="center" class="header" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSubLocationID</STRONG></SPAN></TH><TH align="center" class="header" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSubLocation</STRONG></SPAN></TH><TH align="center" class="header" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSubSubLocationID</STRONG></SPAN></TH><TH align="center" class="header" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSubSubLocation</STRONG></SPAN></TH></TR></THEAD><TBODY><TR><TD style="border: 1px solid #000000;">1</TD><TD style="border: 1px solid #000000;">World</TD><TD style="border: 1px solid #000000;">2</TD><TD style="border: 1px solid #000000;">Europe</TD><TD style="border: 1px solid #000000;">6</TD><TD style="border: 1px solid #000000;">Eastern Europe</TD><TD style="border: 1px solid #000000;">8</TD><TD style="border: 1px solid #000000;">Moscau</TD></TR><TR><TD style="border: 1px solid #000000;">1</TD><TD style="border: 1px solid #000000;">World</TD><TD style="border: 1px solid #000000;">3</TD><TD style="border: 1px solid #000000;">America</TD><TD style="border: 1px solid #000000;">5</TD><TD style="border: 1px solid #000000;">South America</TD><TD style="border: 1px solid #000000;">7</TD><TD style="border: 1px solid #000000;">Sao Paolo</TD></TR><TR><TD style="border: 1px solid #000000;">1</TD><TD style="border: 1px solid #000000;">World</TD><TD style="border: 1px solid #000000;">4</TD><TD style="border: 1px solid #000000;">Africa</TD><TD style="border: 1px solid #000000;">-</TD><TD style="border: 1px solid #000000;">-</TD><TD style="border: 1px solid #000000;">-</TD><TD style="border: 1px solid #000000;">-</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR></TBODY></TABLE><P></P><P>Hope this helps.</P><P>Rochelle</P></BODY></HTML> Wed, 09 Oct 2013 13:41:35 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Parents/m-p/438614#M163504 2013-10-09T13:41:35Z