topic Hierarchical table in QlikView https://community.qlik.com/t5/QlikView/Hierarchical-table/m-p/787006#M278417 <HTML><HEAD></HEAD><BODY><P>Hi all!!!</P><P>I really need your help!</P><P></P><P>I have the following hierarchical table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="327" style="height: 329px; width: 742px;"><TBODY><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Activity_id</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Parent ID</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Ancestor id</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Depth </SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">name</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20391</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">null</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">A</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20395</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20391</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">b</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20394</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20395</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">C</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20397</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20395</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">D</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20398</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20395</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">E</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20396</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20398</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">F</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="62"><P align="center"></P></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>I want to create a pivot table that looks like a tree. I manage to create the Attached table but the 3 level hierarchical isn't working.</P><P>I used the 3 following dimension:</P><P>1- Ancestor ID</P><P>2. if(Depth=2, Parent ID)</P><P>3. if(Depth=2, Activity_id)</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> I don't know how to continue. I try to had the following dimensions : if(Depth=2, Parent ID).... but it's not working.</SPAN></P><P></P><P>I really appreciate your help!!!!! thanks.&nbsp; </P></BODY></HTML> Thu, 20 Nov 2014 10:31:12 GMT 2014-11-20T10:31:12Z Hierarchical table https://community.qlik.com/t5/QlikView/Hierarchical-table/m-p/787006#M278417 <HTML><HEAD></HEAD><BODY><P>Hi all!!!</P><P>I really need your help!</P><P></P><P>I have the following hierarchical table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="327" style="height: 329px; width: 742px;"><TBODY><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Activity_id</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Parent ID</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Ancestor id</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Depth </SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">name</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20391</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">null</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">A</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20395</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20391</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">b</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20394</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20395</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">C</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20397</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20395</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">D</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20398</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20395</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">E</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="103"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20396</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="184"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">20398</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="94"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="126"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="95"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">F</SPAN></P></TD><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P align="center"></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="62"><P align="center"></P></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR><TR><TD style="padding: 0 5.4pt 0 5.4pt;" valign="top" width="62"><P></P></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>I want to create a pivot table that looks like a tree. I manage to create the Attached table but the 3 level hierarchical isn't working.</P><P>I used the 3 following dimension:</P><P>1- Ancestor ID</P><P>2. if(Depth=2, Parent ID)</P><P>3. if(Depth=2, Activity_id)</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> I don't know how to continue. I try to had the following dimensions : if(Depth=2, Parent ID).... but it's not working.</SPAN></P><P></P><P>I really appreciate your help!!!!! thanks.&nbsp; </P></BODY></HTML> Thu, 20 Nov 2014 10:31:12 GMT https://community.qlik.com/t5/QlikView/Hierarchical-table/m-p/787006#M278417 2014-11-20T10:31:12Z