topic HierarchyBelongsTo Help in QlikView https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079716#M359948 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm trying to create a visual scatter chart with HierarchyBelongsTo .&nbsp; I need some help on how to define the "ID", ParentID" and "Node" from the load script. Please see attached Excel highlighted in green.</P><P></P><P></P><P>HierarchyBelongsTo(id, parentid, node, 'ancestorid', 'ancestor', 'layer')</P><P></P><P>Many Thanks,</P><P>Frank</P></BODY></HTML> Mon, 28 Mar 2016 13:22:47 GMT Anonymous 2016-03-28T13:22:47Z HierarchyBelongsTo Help https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079716#M359948 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm trying to create a visual scatter chart with HierarchyBelongsTo .&nbsp; I need some help on how to define the "ID", ParentID" and "Node" from the load script. Please see attached Excel highlighted in green.</P><P></P><P></P><P>HierarchyBelongsTo(id, parentid, node, 'ancestorid', 'ancestor', 'layer')</P><P></P><P>Many Thanks,</P><P>Frank</P></BODY></HTML> Mon, 28 Mar 2016 13:22:47 GMT https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079716#M359948 Anonymous 2016-03-28T13:22:47Z Re: HierarchyBelongsTo Help https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079717#M359949 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P><A href="https://community.qlik.com/thread/46580">Hierarchy Belongs to</A></P><P><A href="https://community.qlik.com/docs/DOC-3899">Hierarchy and Hierarchy Belongs to</A></P></BODY></HTML> Mon, 28 Mar 2016 14:08:56 GMT https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079717#M359949 Chanty4u 2016-03-28T14:08:56Z Re: HierarchyBelongsTo Help https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079718#M359950 <HTML><HEAD></HEAD><BODY><P>Thanks! It's helpful. I wish Jagan's example comes with the excel spreadsheet.&nbsp; What I'm trying to get from the load scripts are the ParentID and ChildID.</P></BODY></HTML> Mon, 28 Mar 2016 14:34:50 GMT https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079718#M359950 Anonymous 2016-03-28T14:34:50Z Re: HierarchyBelongsTo Help https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079719#M359951 <HTML><HEAD></HEAD><BODY><P>Hi Frankie,</P><P></P><P>look at the attachment,</P></BODY></HTML> Mon, 28 Mar 2016 14:40:32 GMT https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079719#M359951 jvishnuram 2016-03-28T14:40:32Z Re: HierarchyBelongsTo Help https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079720#M359952 <HTML><HEAD></HEAD><BODY><P>Thanks Vishnuram! I'm checking it out right now.</P><P></P><P>Can you show me how this works in a visual chart?</P></BODY></HTML> Mon, 28 Mar 2016 15:06:05 GMT https://community.qlik.com/t5/QlikView/HierarchyBelongsTo-Help/m-p/1079720#M359952 Anonymous 2016-03-28T15:06:05Z