topic Regarding Hierarchy in QlikView https://community.qlik.com/t5/QlikView/Regarding-Hierarchy/m-p/993484#M338292 <HTML><HEAD></HEAD><BODY><P>Dear Friends,</P><P></P><P>I appreciate your time. I am trying to build a&nbsp; hierarchy for the following script but not sure how to proceed further. Kindly have a look at the below script or attached application and please let me know.</P><P></P><P>Demo:</P><P>Load * Inline [</P><P>Country,State,City</P><P>Canada,Ontario,Toronto</P><P>Canada ,Alberta,Edmonton</P><P>US,Missouri,SaintLouis</P><P>India,TamilNadu,Coimbatore</P><P>India,Karnataka,Bangalore</P><P>];</P><P></P><P>Demo1:</P><P>Load </P><P>City,</P><P>State,</P><P>Country,</P><P>AutoNumber(City) as CityId,</P><P>AutoNumber(State) as StateId</P><P>Resident Demo;</P><P></P><P>Drop table Demo;</P><P></P><P>Hierarchy(CityId,StateId,City)</P><P>Load</P><P>CityId,</P><P>StateId,</P><P>City,</P><P>State,</P><P>Country</P><P>Resident Demo1;</P><P></P><P></P><P>I am not pretty sure how to create the corresponding nodeid,parentid and link accordingly. Kindly share your ideas!</P><P></P><P>Thanks so much!</P><P></P><P>Kiru</P></BODY></HTML> Thu, 26 Nov 2015 17:10:08 GMT 2015-11-26T17:10:08Z Regarding Hierarchy https://community.qlik.com/t5/QlikView/Regarding-Hierarchy/m-p/993484#M338292 <HTML><HEAD></HEAD><BODY><P>Dear Friends,</P><P></P><P>I appreciate your time. I am trying to build a&nbsp; hierarchy for the following script but not sure how to proceed further. Kindly have a look at the below script or attached application and please let me know.</P><P></P><P>Demo:</P><P>Load * Inline [</P><P>Country,State,City</P><P>Canada,Ontario,Toronto</P><P>Canada ,Alberta,Edmonton</P><P>US,Missouri,SaintLouis</P><P>India,TamilNadu,Coimbatore</P><P>India,Karnataka,Bangalore</P><P>];</P><P></P><P>Demo1:</P><P>Load </P><P>City,</P><P>State,</P><P>Country,</P><P>AutoNumber(City) as CityId,</P><P>AutoNumber(State) as StateId</P><P>Resident Demo;</P><P></P><P>Drop table Demo;</P><P></P><P>Hierarchy(CityId,StateId,City)</P><P>Load</P><P>CityId,</P><P>StateId,</P><P>City,</P><P>State,</P><P>Country</P><P>Resident Demo1;</P><P></P><P></P><P>I am not pretty sure how to create the corresponding nodeid,parentid and link accordingly. Kindly share your ideas!</P><P></P><P>Thanks so much!</P><P></P><P>Kiru</P></BODY></HTML> Thu, 26 Nov 2015 17:10:08 GMT https://community.qlik.com/t5/QlikView/Regarding-Hierarchy/m-p/993484#M338292 2015-11-26T17:10:08Z Re: Regarding Hierarchy https://community.qlik.com/t5/QlikView/Regarding-Hierarchy/m-p/993485#M338293 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Did you check this?</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3899">Hierarchy and Hierarchy Belongs to</A></P></BODY></HTML> Thu, 26 Nov 2015 17:13:43 GMT https://community.qlik.com/t5/QlikView/Regarding-Hierarchy/m-p/993485#M338293 settu_periasamy 2015-11-26T17:13:43Z Re: Regarding Hierarchy https://community.qlik.com/t5/QlikView/Regarding-Hierarchy/m-p/993486#M338294 <HTML><HEAD></HEAD><BODY><P>Hi Settu,</P><P></P><P>Thanks for your time. I am just wondering the way to create the id.</P><P>ie the nodeid and parentid.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 26 Nov 2015 17:32:07 GMT https://community.qlik.com/t5/QlikView/Regarding-Hierarchy/m-p/993486#M338294 2015-11-26T17:32:07Z