topic Need help for creating hierarchy for this Dataset in QlikView https://community.qlik.com/t5/QlikView/Need-help-for-creating-hierarchy-for-this-Dataset/m-p/612685#M226099 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to create a hierarchy based on the attached Data-Set.</P><P></P><P>Any help would be appreciated.</P><P></P><P>Thanks in advance.</P><P></P><P>The hierarchy should be like this for the attached data-set.</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SalesRepCode</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepName</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepCode</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepName</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepCode</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepName</TH></TR><TR><TD style="padding: 2px;">Level 9</TD><TD style="padding: 2px;">32230</TD><TD style="padding: 2px;">Ahmed</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Level 8</TD><TD style="padding: 2px;">30818</TD><TD style="padding: 2px;">Jamali</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Level 7</TD><TD style="padding: 2px;">32087</TD><TD style="padding: 2px;">Umer</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Level 7</TD><TD style="padding: 2px;">39927</TD><TD style="padding: 2px;">Qaim</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Level 7</TD><TD style="padding: 2px;">57455</TD><TD style="padding: 2px;">Bilal</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 08 Apr 2014 07:51:31 GMT Anonymous 2014-04-08T07:51:31Z Need help for creating hierarchy for this Dataset https://community.qlik.com/t5/QlikView/Need-help-for-creating-hierarchy-for-this-Dataset/m-p/612685#M226099 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to create a hierarchy based on the attached Data-Set.</P><P></P><P>Any help would be appreciated.</P><P></P><P>Thanks in advance.</P><P></P><P>The hierarchy should be like this for the attached data-set.</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SalesRepCode</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepName</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepCode</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepName</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Level Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepCode</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SalesRepName</TH></TR><TR><TD style="padding: 2px;">Level 9</TD><TD style="padding: 2px;">32230</TD><TD style="padding: 2px;">Ahmed</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Level 8</TD><TD style="padding: 2px;">30818</TD><TD style="padding: 2px;">Jamali</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Level 7</TD><TD style="padding: 2px;">32087</TD><TD style="padding: 2px;">Umer</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Level 7</TD><TD style="padding: 2px;">39927</TD><TD style="padding: 2px;">Qaim</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Level 7</TD><TD style="padding: 2px;">57455</TD><TD style="padding: 2px;">Bilal</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 08 Apr 2014 07:51:31 GMT https://community.qlik.com/t5/QlikView/Need-help-for-creating-hierarchy-for-this-Dataset/m-p/612685#M226099 Anonymous 2014-04-08T07:51:31Z Re: Need help for creating hierarchy for this Dataset https://community.qlik.com/t5/QlikView/Need-help-for-creating-hierarchy-for-this-Dataset/m-p/612686#M226100 <HTML><HEAD></HEAD><BODY><P>Still awaiting for the response. </P></BODY></HTML> Wed, 09 Apr 2014 16:12:05 GMT https://community.qlik.com/t5/QlikView/Need-help-for-creating-hierarchy-for-this-Dataset/m-p/612686#M226100 Anonymous 2014-04-09T16:12:05Z Re: Need help for creating hierarchy for this Dataset https://community.qlik.com/t5/QlikView/Need-help-for-creating-hierarchy-for-this-Dataset/m-p/612687#M226101 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I some how managed to make the hierarchy by visiting various community threads.</P><P></P><P>Please find the attached Qvw + .Xls for demonstration.</P><P></P><P>Regards,</P><P>Hassam Ahmed.</P></BODY></HTML> Thu, 10 Apr 2014 09:12:27 GMT https://community.qlik.com/t5/QlikView/Need-help-for-creating-hierarchy-for-this-Dataset/m-p/612687#M226101 Anonymous 2014-04-10T09:12:27Z