topic Re: Recuring Routine to Build Hierarchy Levels in QlikView https://community.qlik.com/t5/QlikView/Recuring-Routine-to-Build-Hierarchy-Levels/m-p/485635#M181435 <HTML><HEAD></HEAD><BODY><P>The Hierarchy prefix does exactly this.</P><P></P><P>Hierarchy (ResourceID, ManagerID, Resource)</P><P>Load </P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Resource as ResourceID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Resource,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Manager as ManagerID</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;From ...</P><P></P><P>HIC</P></BODY></HTML> Mon, 12 Aug 2013 15:34:48 GMT hic 2013-08-12T15:34:48Z Recuring Routine to Build Hierarchy Levels https://community.qlik.com/t5/QlikView/Recuring-Routine-to-Build-Hierarchy-Levels/m-p/485634#M181434 <HTML><HEAD></HEAD><BODY><P>I have a lookup table with two columns:&nbsp; Resource and Manager </P><P></P><P></P><P>Resource&nbsp;&nbsp;&nbsp;&nbsp; Manager</P><P>________&nbsp;&nbsp;&nbsp;&nbsp; _______</P><P>Jones&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wilson</P><P>Smith&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wilson </P><P>Thomas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Andrews</P><P>Wilson&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thomas</P><P></P><P></P><P>Resource&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Director&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AVP</P><P>________&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _______&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _______&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ____</P><P>Jones&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wilson&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thomas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Andrews</P><P>Smith&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wilson&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thomas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Andrews</P><P></P><P></P><P></P><P>I need to write a recursive routine to build out 5 level of management Hierarchy: Resource-Manager-Director-AVP-VP.</P><P></P><P>This is done by taking the original Resource and going back to the lookup table, assigning the Manager as the Resource - and taking the returned Manager value and making it the Director. - etc. etc...</P><P></P><P></P><P>Any Help?</P></BODY></HTML> Mon, 12 Aug 2013 14:44:29 GMT https://community.qlik.com/t5/QlikView/Recuring-Routine-to-Build-Hierarchy-Levels/m-p/485634#M181434 2013-08-12T14:44:29Z Re: Recuring Routine to Build Hierarchy Levels https://community.qlik.com/t5/QlikView/Recuring-Routine-to-Build-Hierarchy-Levels/m-p/485635#M181435 <HTML><HEAD></HEAD><BODY><P>The Hierarchy prefix does exactly this.</P><P></P><P>Hierarchy (ResourceID, ManagerID, Resource)</P><P>Load </P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Resource as ResourceID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Resource,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Manager as ManagerID</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;From ...</P><P></P><P>HIC</P></BODY></HTML> Mon, 12 Aug 2013 15:34:48 GMT https://community.qlik.com/t5/QlikView/Recuring-Routine-to-Build-Hierarchy-Levels/m-p/485635#M181435 hic 2013-08-12T15:34:48Z