topic heirarchy in QlikView https://community.qlik.com/t5/QlikView/heirarchy/m-p/298452#M110683 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use Qualify'*' for all fields except joining key</P><P>Use Unqualiy 'Key_*' for joining key at the begning of loop</P><P></P><P>Thanks</P><P>Vivek</P></BODY></HTML> Wed, 14 Dec 2011 08:22:41 GMT 2011-12-14T08:22:41Z heirarchy https://community.qlik.com/t5/QlikView/heirarchy/m-p/298451#M110682 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I have a list of history files which I loop through to create a heirarchy on the users. This works fine, but when I left join to another list of history files it creates a massive synthetic key and numerous tables. Basically I would like to know if ther is a special way of joining tables in a for each loop.</P><P></P><P></P><P>thank you in advance</P><P></P><P>Kamiel</P></BODY></HTML> Wed, 14 Dec 2011 08:13:07 GMT https://community.qlik.com/t5/QlikView/heirarchy/m-p/298451#M110682 kamielrajaram 2011-12-14T08:13:07Z heirarchy https://community.qlik.com/t5/QlikView/heirarchy/m-p/298452#M110683 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use Qualify'*' for all fields except joining key</P><P>Use Unqualiy 'Key_*' for joining key at the begning of loop</P><P></P><P>Thanks</P><P>Vivek</P></BODY></HTML> Wed, 14 Dec 2011 08:22:41 GMT https://community.qlik.com/t5/QlikView/heirarchy/m-p/298452#M110683 2011-12-14T08:22:41Z