https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234433#M85851 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P>see the attached example.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Tue, 01 Mar 2011 13:58:24 GMT 2011-03-01T13:58:24Z https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234432#M85850 <HTML><HEAD></HEAD><BODY><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7635.Hierarchie.xls:550:0]</P><P>Hello,</P><P>I need a hierarchy from an excel sheet. The goal is to see managers, department managers and employees in an hierarchial structure.</P><P>Can anyone solve the problem? See the attached file.</P><P>Greetings,</P><P>Michael</P><P></P></BODY></HTML> Tue, 01 Mar 2011 13:43:06 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234432#M85850 2011-03-01T13:43:06Z https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234433#M85851 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P>see the attached example.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Tue, 01 Mar 2011 13:58:24 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234433#M85851 2011-03-01T13:58:24Z https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234434#M85852 <HTML><HEAD></HEAD><BODY><P>Hello Rainer,</P><P>i tried to build up the hierarchy by using an example from another post. But it does not work, can you help?</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;"><A id="OLE_LINK2" name="OLE_LINK2"></A><A id="OLE_LINK1" name="OLE_LINK1"><I>data:</I></A></P><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-layout-grid-align: none">LOAD</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;">Geschäftsführer,</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;">Abteilungsleiter,</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;">Mitarbeiter</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;"><B>FROM</B> C:/Hierarchie.xls(ooxml, embedded labels, table is Tabelle1);</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;"></P><P style="font-style: italic; margin: 0cm 0cm 0pt; mso-layout-grid-align: none">DrillDown:</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;"><B>HIERARCHY</B> (Geschäftsführer, Abteilungsleiter, Mitarbeiter, 'Tree View', '/')</P><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-layout-grid-align: none">LOAD</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;">Geschäftsführer,</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;">Abteilungsleiter,</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;">Mitarbeiter</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;"><B>RESIDENT</B> data;</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;"><B>Drop</B> <B>Table</B> <I>data;</I></P><P></P><P style="margin:0cm 0cm 0pt;">The Excel looks like this:</P><P style="margin:0cm 0cm 0pt;"></P><P style="margin:0cm 0cm 0pt;">Geschäftsführer Abteilungsleiter Mitarbeiter</P><P style="margin:0cm 0cm 0pt;">1 23 2</P><P style="margin:0cm 0cm 0pt;">1 23 3</P><P style="margin:0cm 0cm 0pt;">... .... ....</P><P style="margin:0cm 0cm 0pt;"></P><P style="margin:0cm 0cm 0pt;">Michael</P><P style="margin:0cm 0cm 0pt;"></P></BODY></HTML> Wed, 02 Mar 2011 09:10:06 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234434#M85852 2011-03-02T09:10:06Z https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234435#M85853 <HTML><HEAD></HEAD><BODY><P>Hallo, Michiha85,</P><P>du brauchst besser eine Tabelle die so aussieht:</P><P>Chef Mitarbeiter<BR /> 1<BR /> 1 23<BR /> 23 2<BR /> 23 3<BR /> 23 4<BR /> 1 24<BR /> 24 5<BR /> 24 6<BR /> 24 7<BR /> 7 8<BR /> 7 9<BR />.....</P><P>Das löst die Hierarchy dann automatisch auf.</P></BODY></HTML> Wed, 02 Mar 2011 09:24:42 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234435#M85853 brenner_martina 2011-03-02T09:24:42Z https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234436#M85854 <HTML><HEAD></HEAD><BODY><P>Hallo Martina,</P><P>wie würde dann das Load Script dafür aussehen? Ich arbeite erst seit kurzem mit QlikView und es ist alles noch ein wenig verwirrend <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P><P>Michael</P></BODY></HTML> Wed, 02 Mar 2011 09:45:24 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234436#M85854 2011-03-02T09:45:24Z https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234437#M85855 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P>here are an example based on your excel file.</P><P>The kind of table Martina mentioned are used most if we talking about hierarchies.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Wed, 02 Mar 2011 09:58:06 GMT https://community.qlik.com/t5/QlikView/Hierarchy-Manager-Department-Manager-Employee/m-p/234437#M85855 2011-03-02T09:58:06Z