topic Re: Hierarchy without parent ? in QlikView https://community.qlik.com/t5/QlikView/Hierarchy-without-parent/m-p/1111346#M633907 <HTML><HEAD></HEAD><BODY><P>WHEN THE DATA&nbsp; LOAD THE TO NEXT BUTTON MULTIPLE TYPE AT THE STAGE HAVE CROSSTABLE AND HIRCHACHY TO GIVE THE HIERCHAY</P></BODY></HTML> Tue, 10 May 2016 09:42:56 GMT Anonymous 2016-05-10T09:42:56Z Hierarchy without parent ? https://community.qlik.com/t5/QlikView/Hierarchy-without-parent/m-p/1111345#M633906 <HTML><HEAD></HEAD><BODY><P>I have a customer table in which some customers have the same parent. Mostly the customer does not have a parent.</P><P></P><P>How can I create a hierarchy in this situation? I want to show the ChildID as ParentID when no parent is entered in the database. Easy done with an if statement, but I posted the raw data below in the print screen for your reviewing.</P><P></P><P>I started with <EM>Hierarchy (ChildID, ParentID,ClientKey)</EM>.</P><P>ClientKey will be used to link to the name of the client.</P><P></P><P>I want to display the Parent to child relation in an listbox.</P><P><IMG __jive_id="124091" alt="2016-05-10 11_31_53-QlikView x64 - [D__Auren interne rapportages_MI_Auren_2_Workbooks_CTS hierarchy .jpg" class="jive-image image-1" src="/legacyfs/online/124091_2016-05-10 11_31_53-QlikView x64 - [D__Auren interne rapportages_MI_Auren_2_Workbooks_CTS hierarchy .jpg" style="height: auto;" /></P><P></P><P>My question: what should the hierarchy statement be to generate the desired List box. With the current statement I don't have a field that acts as as desired</P></BODY></HTML> Tue, 10 May 2016 09:37:13 GMT https://community.qlik.com/t5/QlikView/Hierarchy-without-parent/m-p/1111345#M633906 Michiel_QV_Fan 2016-05-10T09:37:13Z Re: Hierarchy without parent ? https://community.qlik.com/t5/QlikView/Hierarchy-without-parent/m-p/1111346#M633907 <HTML><HEAD></HEAD><BODY><P>WHEN THE DATA&nbsp; LOAD THE TO NEXT BUTTON MULTIPLE TYPE AT THE STAGE HAVE CROSSTABLE AND HIRCHACHY TO GIVE THE HIERCHAY</P></BODY></HTML> Tue, 10 May 2016 09:42:56 GMT https://community.qlik.com/t5/QlikView/Hierarchy-without-parent/m-p/1111346#M633907 Anonymous 2016-05-10T09:42:56Z Re: Hierarchy without parent ? https://community.qlik.com/t5/QlikView/Hierarchy-without-parent/m-p/1111347#M633908 <HTML><HEAD></HEAD><BODY><P>If you don't have the Parent ID then your approach is rite <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 10 May 2016 10:54:17 GMT https://community.qlik.com/t5/QlikView/Hierarchy-without-parent/m-p/1111347#M633908 avinashelite 2016-05-10T10:54:17Z