topic Hierarchy in QlikView https://community.qlik.com/t5/QlikView/Hierarchy/m-p/382937#M142919 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have problem with how to create a proper hierarchy in qlikview script. Lets say my source date contains a table with all the records (Records table) and a hierarchy table (Records_Hierarchy) which tells that a certain record has a certain ancestor in the same records -table. </P><P></P><P></P><P>Records:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record_Id</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record_Name</P><P></P><P>Records_Hierarchy:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record_Id</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Ancestor_Record_Id</P><P></P><P>The hierarchy can be deeper than two levels (if that is the correct way to say it), or the record might not have any ancestors:</P><P></P><P>Record1&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Record3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Record4</P><P>Record5</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record7</P><P>Record8</P><P>Record9</P><P></P><P>How can I create qlikview to model this? </P><P></P><P>Thank you!</P></BODY></HTML> Fri, 31 Aug 2012 10:32:11 GMT 2012-08-31T10:32:11Z Hierarchy https://community.qlik.com/t5/QlikView/Hierarchy/m-p/382937#M142919 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have problem with how to create a proper hierarchy in qlikview script. Lets say my source date contains a table with all the records (Records table) and a hierarchy table (Records_Hierarchy) which tells that a certain record has a certain ancestor in the same records -table. </P><P></P><P></P><P>Records:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record_Id</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record_Name</P><P></P><P>Records_Hierarchy:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record_Id</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Ancestor_Record_Id</P><P></P><P>The hierarchy can be deeper than two levels (if that is the correct way to say it), or the record might not have any ancestors:</P><P></P><P>Record1&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Record3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Record4</P><P>Record5</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Record7</P><P>Record8</P><P>Record9</P><P></P><P>How can I create qlikview to model this? </P><P></P><P>Thank you!</P></BODY></HTML> Fri, 31 Aug 2012 10:32:11 GMT https://community.qlik.com/t5/QlikView/Hierarchy/m-p/382937#M142919 2012-08-31T10:32:11Z Re: Hierarchy https://community.qlik.com/t5/QlikView/Hierarchy/m-p/382938#M142920 <HTML><HEAD></HEAD><BODY><P>Refer this link <A _jive_internal="true" href="https://community.qlik.com/message/253081">http://community.qlik.com/message/253081</A></P></BODY></HTML> Fri, 31 Aug 2012 10:45:26 GMT https://community.qlik.com/t5/QlikView/Hierarchy/m-p/382938#M142920 sivarajs 2012-08-31T10:45:26Z