topic How to Find Highest level in hierarchy in QlikView https://community.qlik.com/t5/QlikView/How-to-Find-Highest-level-in-hierarchy/m-p/533700#M694829 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a table that contain a list of accounts in a hierarchical format. (for example, level 1 to 5) The account table looks like this:-</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level 1</STRONG></SPAN><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level </STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level </STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>4</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level </STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>5</STRONG></SPAN></TH></TR><TR><TD>11100</TD><TD>11100</TD><TD>11100</TD><TD>11000</TD><TD>10000</TD></TR><TR><TD>11200</TD><TD>11200</TD><TD>11200</TD><TD>11000</TD><TD>10000</TD></TR><TR><TD>11300</TD><TD>11300</TD><TD>11300</TD><TD>11000</TD><TD>10000</TD></TR><TR><TD>12100</TD><TD>12100</TD><TD>12100</TD><TD>12000</TD><TD>10000</TD></TR><TR><TD>12200</TD><TD>12200</TD><TD>12200</TD><TD>12000</TD><TD>10000</TD></TR></TBODY></TABLE><P></P><P>Level 1 is the lowest level and Level 5 is the highest. Level 1 is linked to the fact table. Now, my question is if I'm given an account number without knowing the level, how can I find the accounts of the lowest level?</P><P></P><P>For example (Based on the above sample):</P><P>If account 11000 is given, the accounts that should be returned are 11100, 11200, 11300.</P><P>If account 10000 is given, the accounts that should be returned are 11100, 11200, 11300, 12100, 12200.</P><P>If account 12100 is given, the accounts that should be returned are 12100.</P><P></P><P>Some note:-</P><P>- account number is unique</P><P>- there is not pattern in the account number. All account numbers are randomly created.</P></BODY></HTML> Wed, 03 Jul 2013 05:53:09 GMT 2013-07-03T05:53:09Z How to Find Highest level in hierarchy https://community.qlik.com/t5/QlikView/How-to-Find-Highest-level-in-hierarchy/m-p/533700#M694829 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a table that contain a list of accounts in a hierarchical format. (for example, level 1 to 5) The account table looks like this:-</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level 1</STRONG></SPAN><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level </STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level </STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>4</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level </STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>5</STRONG></SPAN></TH></TR><TR><TD>11100</TD><TD>11100</TD><TD>11100</TD><TD>11000</TD><TD>10000</TD></TR><TR><TD>11200</TD><TD>11200</TD><TD>11200</TD><TD>11000</TD><TD>10000</TD></TR><TR><TD>11300</TD><TD>11300</TD><TD>11300</TD><TD>11000</TD><TD>10000</TD></TR><TR><TD>12100</TD><TD>12100</TD><TD>12100</TD><TD>12000</TD><TD>10000</TD></TR><TR><TD>12200</TD><TD>12200</TD><TD>12200</TD><TD>12000</TD><TD>10000</TD></TR></TBODY></TABLE><P></P><P>Level 1 is the lowest level and Level 5 is the highest. Level 1 is linked to the fact table. Now, my question is if I'm given an account number without knowing the level, how can I find the accounts of the lowest level?</P><P></P><P>For example (Based on the above sample):</P><P>If account 11000 is given, the accounts that should be returned are 11100, 11200, 11300.</P><P>If account 10000 is given, the accounts that should be returned are 11100, 11200, 11300, 12100, 12200.</P><P>If account 12100 is given, the accounts that should be returned are 12100.</P><P></P><P>Some note:-</P><P>- account number is unique</P><P>- there is not pattern in the account number. All account numbers are randomly created.</P></BODY></HTML> Wed, 03 Jul 2013 05:53:09 GMT https://community.qlik.com/t5/QlikView/How-to-Find-Highest-level-in-hierarchy/m-p/533700#M694829 2013-07-03T05:53:09Z Re: How to Find Highest level in hierarchy https://community.qlik.com/t5/QlikView/How-to-Find-Highest-level-in-hierarchy/m-p/533701#M694830 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Wed, 03 Jul 2013 18:37:19 GMT https://community.qlik.com/t5/QlikView/How-to-Find-Highest-level-in-hierarchy/m-p/533701#M694830 Gysbert_Wassenaar 2013-07-03T18:37:19Z Re: How to Find Highest level in hierarchy https://community.qlik.com/t5/QlikView/How-to-Find-Highest-level-in-hierarchy/m-p/533702#M694831 <HTML><HEAD></HEAD><BODY><P>Thanks! Works perfectly. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 04 Jul 2013 02:43:18 GMT https://community.qlik.com/t5/QlikView/How-to-Find-Highest-level-in-hierarchy/m-p/533702#M694831 2013-07-04T02:43:18Z