topic How to display a hierarchy ? in QlikView https://community.qlik.com/t5/QlikView/How-to-display-a-hierarchy/m-p/1558972#M441111 <P>Hello:</P><P>Following&nbsp;&nbsp;<A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6622" target="_self">@HIC</A> instructions in his&nbsp;<A title="Hierarchies" href="https://community.qlik.com/t5/QlikView-Documents/Hierarchies/ta-p/1487801" target="_self">Hierarchies</A>&nbsp;blog,&nbsp; I have developed a n-levels unbalanced hierarchy, as you can see it in the attached qvw</P><P>The data model seems to be correct, but I'm not able to show a tree exploding each level (TASK) and below every own child-level (SUBTASK) completely expanded&nbsp;</P><P>This table is what I need to get, but my charts don't work with lines in red&nbsp;</P><TABLE><TBODY><TR><TD>Project</TD><TD>RecNo</TD><TD>SUBTASK</TD><TD>TASK</TD><TD>ID_Level</TD><TD>Node</TD></TR><TR><TD>946549-1-R5-D</TD><TD>6</TD><TD>230898</TD><TD>&nbsp;</TD><TD>1</TD><TD>DETAIL_REQUEST</TD></TR><TR><TD>946549-1-R5-D</TD><TD>8</TD><TD>266070</TD><TD>230898</TD><TD>2</TD><TD>DETAIL_REQUEST</TD></TR><TR><TD><FONT color="#FF0000">946549-1-R5-D</FONT></TD><TD><FONT color="#FF0000">5</FONT></TD><TD><FONT color="#FF0000">267552</FONT></TD><TD><FONT color="#FF0000">266070</FONT></TD><TD><FONT color="#FF0000">3</FONT></TD><TD><FONT color="#FF0000">NEW</FONT></TD></TR><TR><TD>946549-1-R5-D</TD><TD>3</TD><TD>266071</TD><TD>230898</TD><TD>2</TD><TD>DETAIL_REQUEST</TD></TR><TR><TD>946549-1-R5-D</TD><TD>10</TD><TD>267320</TD><TD>266071</TD><TD>3</TD><TD>LAYOUT</TD></TR><TR><TD>946549-1-R5-D</TD><TD>9</TD><TD>267877</TD><TD>266071</TD><TD>3</TD><TD>DOCUMENTATION</TD></TR><TR><TD>946549-1-R5-D</TD><TD>7</TD><TD>276172</TD><TD>266071</TD><TD>3</TD><TD>ELECTRICAL_ENGINEERING_INSTALLATION</TD></TR><TR><TD><FONT color="#FF0000">946549-1-R5-D</FONT></TD><TD><FONT color="#FF0000">2</FONT></TD><TD><FONT color="#FF0000">276209</FONT></TD><TD><FONT color="#FF0000">276172</FONT></TD><TD><FONT color="#FF0000">4</FONT></TD><TD><FONT color="#FF0000">ELECTRICAL_ENGINEERING_INSTALLATION</FONT></TD></TR><TR><TD>946549-1-R5-D</TD><TD>1</TD><TD>276174</TD><TD>266071</TD><TD>3</TD><TD>NO_STD_MACHINERY</TD></TR><TR><TD>946549-1-R5-D</TD><TD>4</TD><TD>279338</TD><TD>276174</TD><TD>4</TD><TD>NO_STD_MACHINERY</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What am I doing wrong ?</P><P>Which is the right way to do this ?</P><P>&nbsp;</P><P>Any help will be appreciated</P><P>Thank you&nbsp;</P><P>Joaquín</P><P>&nbsp;</P> Sat, 16 Nov 2024 21:12:52 GMT Joaquin_Lazaro 2024-11-16T21:12:52Z How to display a hierarchy ? https://community.qlik.com/t5/QlikView/How-to-display-a-hierarchy/m-p/1558972#M441111 <P>Hello:</P><P>Following&nbsp;&nbsp;<A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6622" target="_self">@HIC</A> instructions in his&nbsp;<A title="Hierarchies" href="https://community.qlik.com/t5/QlikView-Documents/Hierarchies/ta-p/1487801" target="_self">Hierarchies</A>&nbsp;blog,&nbsp; I have developed a n-levels unbalanced hierarchy, as you can see it in the attached qvw</P><P>The data model seems to be correct, but I'm not able to show a tree exploding each level (TASK) and below every own child-level (SUBTASK) completely expanded&nbsp;</P><P>This table is what I need to get, but my charts don't work with lines in red&nbsp;</P><TABLE><TBODY><TR><TD>Project</TD><TD>RecNo</TD><TD>SUBTASK</TD><TD>TASK</TD><TD>ID_Level</TD><TD>Node</TD></TR><TR><TD>946549-1-R5-D</TD><TD>6</TD><TD>230898</TD><TD>&nbsp;</TD><TD>1</TD><TD>DETAIL_REQUEST</TD></TR><TR><TD>946549-1-R5-D</TD><TD>8</TD><TD>266070</TD><TD>230898</TD><TD>2</TD><TD>DETAIL_REQUEST</TD></TR><TR><TD><FONT color="#FF0000">946549-1-R5-D</FONT></TD><TD><FONT color="#FF0000">5</FONT></TD><TD><FONT color="#FF0000">267552</FONT></TD><TD><FONT color="#FF0000">266070</FONT></TD><TD><FONT color="#FF0000">3</FONT></TD><TD><FONT color="#FF0000">NEW</FONT></TD></TR><TR><TD>946549-1-R5-D</TD><TD>3</TD><TD>266071</TD><TD>230898</TD><TD>2</TD><TD>DETAIL_REQUEST</TD></TR><TR><TD>946549-1-R5-D</TD><TD>10</TD><TD>267320</TD><TD>266071</TD><TD>3</TD><TD>LAYOUT</TD></TR><TR><TD>946549-1-R5-D</TD><TD>9</TD><TD>267877</TD><TD>266071</TD><TD>3</TD><TD>DOCUMENTATION</TD></TR><TR><TD>946549-1-R5-D</TD><TD>7</TD><TD>276172</TD><TD>266071</TD><TD>3</TD><TD>ELECTRICAL_ENGINEERING_INSTALLATION</TD></TR><TR><TD><FONT color="#FF0000">946549-1-R5-D</FONT></TD><TD><FONT color="#FF0000">2</FONT></TD><TD><FONT color="#FF0000">276209</FONT></TD><TD><FONT color="#FF0000">276172</FONT></TD><TD><FONT color="#FF0000">4</FONT></TD><TD><FONT color="#FF0000">ELECTRICAL_ENGINEERING_INSTALLATION</FONT></TD></TR><TR><TD>946549-1-R5-D</TD><TD>1</TD><TD>276174</TD><TD>266071</TD><TD>3</TD><TD>NO_STD_MACHINERY</TD></TR><TR><TD>946549-1-R5-D</TD><TD>4</TD><TD>279338</TD><TD>276174</TD><TD>4</TD><TD>NO_STD_MACHINERY</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What am I doing wrong ?</P><P>Which is the right way to do this ?</P><P>&nbsp;</P><P>Any help will be appreciated</P><P>Thank you&nbsp;</P><P>Joaquín</P><P>&nbsp;</P> Sat, 16 Nov 2024 21:12:52 GMT https://community.qlik.com/t5/QlikView/How-to-display-a-hierarchy/m-p/1558972#M441111 Joaquin_Lazaro 2024-11-16T21:12:52Z