topic Re: Generating tree-like hierarchy from a flattened table in QlikView https://community.qlik.com/t5/QlikView/Generating-tree-like-hierarchy-from-a-flattened-table/m-p/1442674#M797924 <HTML><HEAD></HEAD><BODY><P>May be look?</P><P><IMG alt="Capture.JPG" class="jive-image image-1" height="230" src="https://community.qlik.com/legacyfs/online/186024_Capture.JPG" style="height: 230px; width: 135.556px;" width="136" /></P></BODY></HTML> Thu, 07 Dec 2017 02:03:04 GMT Anil_Babu_Samineni 2017-12-07T02:03:04Z Generating tree-like hierarchy from a flattened table https://community.qlik.com/t5/QlikView/Generating-tree-like-hierarchy-from-a-flattened-table/m-p/1442673#M797923 <HTML><HEAD></HEAD><BODY><P>I have a hierarchy of Id that are flattened into a table structure, as per the attachment. Each Id (except for topmost node) has a ParentId</P><P></P><P>For example, <SPAN style="color: #339966;">5a287a7bfc13ae4ab60003fa</SPAN><SPAN style="color: black;"><SPAN style="color: #339966;"> </SPAN>has parent </SPAN><SPAN style="color: #339966;">5a287a7bfc13ae4ab600042f </SPAN><SPAN style="color: black;">but</SPAN> <EM style="color: black;">subsequently</EM><SPAN class="IntenseQuoteChar"> <SPAN style="color: #339966;">5a287a7bfc13ae4ab60003fa</SPAN></SPAN><SPAN style="color: black;"><SPAN style="color: #339966;"> </SPAN>is itself represented under ParentId column with its child nodes mentioned under Id column</SPAN></P><P><SPAN style="color: black;"><BR /></SPAN></P><P>Can someone suggest how to transform this structure into a Qlik tree-like hierarchy</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Generating-tree-like-hierarchy-from-a-flattened-table/m-p/1442673#M797923 kundan_ghosh 2020-11-25T16:16:04Z Re: Generating tree-like hierarchy from a flattened table https://community.qlik.com/t5/QlikView/Generating-tree-like-hierarchy-from-a-flattened-table/m-p/1442674#M797924 <HTML><HEAD></HEAD><BODY><P>May be look?</P><P><IMG alt="Capture.JPG" class="jive-image image-1" height="230" src="https://community.qlik.com/legacyfs/online/186024_Capture.JPG" style="height: 230px; width: 135.556px;" width="136" /></P></BODY></HTML> Thu, 07 Dec 2017 02:03:04 GMT https://community.qlik.com/t5/QlikView/Generating-tree-like-hierarchy-from-a-flattened-table/m-p/1442674#M797924 Anil_Babu_Samineni 2017-12-07T02:03:04Z