topic Hierarchy Load in QlikView https://community.qlik.com/t5/QlikView/Hierarchy-Load/m-p/494522#M557920 <HTML><HEAD></HEAD><BODY><P>I have below raw data.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="246"><TBODY><TR><TD height="20" width="101">Entity</TD><TD width="81">Parent</TD><TD width="64">Value</TD></TR><TR><TD height="20">USA</TD><TD><BR /></TD><TD align="right">150</TD></TR><TR><TD height="20">Connecticut</TD><TD>USA</TD><TD align="right">30</TD></TR><TR><TD height="20">Danbury</TD><TD>Connecticut</TD><TD align="right">10</TD></TR><TR><TD height="20">Southbury</TD><TD>Connecticut</TD><TD align="right">20</TD></TR><TR><TD height="20">Texas</TD><TD>USA</TD><TD align="right">90</TD></TR><TR><TD height="20">Houston</TD><TD>Texas</TD><TD align="right">40</TD></TR><TR><TD height="20">Dallas</TD><TD>Texas</TD><TD align="right">50</TD></TR><TR><TD height="20">Alabama</TD><TD>USA</TD><TD align="right">30</TD></TR></TBODY></TABLE><P></P><P>How can I get a table in QlikView from above raw data to look like below (lowest level entity)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="182"><TBODY><TR><TD height="20" width="101">Entity</TD><TD width="81">Value</TD></TR><TR><TD height="20">Danbury</TD><TD align="right">10</TD></TR><TR><TD height="20">Southbury</TD><TD align="right">20</TD></TR><TR><TD height="20">Houston</TD><TD align="right">40</TD></TR><TR><TD height="20">Dallas</TD><TD align="right">50</TD></TR><TR><TD height="20">Alabama</TD><TD align="right">30</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Thu, 20 Jun 2013 20:44:12 GMT Anonymous 2013-06-20T20:44:12Z Hierarchy Load https://community.qlik.com/t5/QlikView/Hierarchy-Load/m-p/494522#M557920 <HTML><HEAD></HEAD><BODY><P>I have below raw data.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="246"><TBODY><TR><TD height="20" width="101">Entity</TD><TD width="81">Parent</TD><TD width="64">Value</TD></TR><TR><TD height="20">USA</TD><TD><BR /></TD><TD align="right">150</TD></TR><TR><TD height="20">Connecticut</TD><TD>USA</TD><TD align="right">30</TD></TR><TR><TD height="20">Danbury</TD><TD>Connecticut</TD><TD align="right">10</TD></TR><TR><TD height="20">Southbury</TD><TD>Connecticut</TD><TD align="right">20</TD></TR><TR><TD height="20">Texas</TD><TD>USA</TD><TD align="right">90</TD></TR><TR><TD height="20">Houston</TD><TD>Texas</TD><TD align="right">40</TD></TR><TR><TD height="20">Dallas</TD><TD>Texas</TD><TD align="right">50</TD></TR><TR><TD height="20">Alabama</TD><TD>USA</TD><TD align="right">30</TD></TR></TBODY></TABLE><P></P><P>How can I get a table in QlikView from above raw data to look like below (lowest level entity)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="182"><TBODY><TR><TD height="20" width="101">Entity</TD><TD width="81">Value</TD></TR><TR><TD height="20">Danbury</TD><TD align="right">10</TD></TR><TR><TD height="20">Southbury</TD><TD align="right">20</TD></TR><TR><TD height="20">Houston</TD><TD align="right">40</TD></TR><TR><TD height="20">Dallas</TD><TD align="right">50</TD></TR><TR><TD height="20">Alabama</TD><TD align="right">30</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Thu, 20 Jun 2013 20:44:12 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Load/m-p/494522#M557920 Anonymous 2013-06-20T20:44:12Z