topic Heirarchy Report in QlikView https://community.qlik.com/t5/QlikView/Heirarchy-Report/m-p/785168#M277847 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Is it possible to create the report as in below format.please suggest.</P><P></P><P>I need with in one dimension first Manager data&nbsp; should come and then reportee information.</P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 424px; border-collapse: collapse;"><TBODY><TR style="height: 15pt;"><TD class="xl63" height="20" style="border: 0.5pt solid windowtext; width: 64pt; height: 15pt; background-color: #5b9bd5;" width="85"><STRONG style="font-family: Calibri;">Name</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: #5b9bd5;" width="64"><STRONG style="font-family: Calibri;">Q1 T</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: #5b9bd5;" width="64"><STRONG style="font-family: Calibri;">Q1 A</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 62pt; background-color: #5b9bd5;" width="83"><STRONG style="font-family: Calibri;">% age</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: #5b9bd5;" width="64"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Q2 T</STRONG></TD> <TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: #5b9bd5;" width="64"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Q2 A</STRONG></TD> </TR> <TR style="height: 15pt;"><TD class="xl64" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 15pt; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Manager</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Agg A</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Agg A</SPAN></TD> </TR> <TR style="height: 15pt;"> <TD class="xl66" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 15pt; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Reportee 1</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Rep T</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Rep A</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Rep T/Rep A</SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> </TR> <TR style="height: 15pt;"> <TD class="xl66" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 15pt; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Reportee 2</SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> </TR> </TBODY></TABLE><P><BR /> </P></BODY></HTML> Wed, 24 Dec 2014 09:40:14 GMT svsudhakar 2014-12-24T09:40:14Z Heirarchy Report https://community.qlik.com/t5/QlikView/Heirarchy-Report/m-p/785168#M277847 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Is it possible to create the report as in below format.please suggest.</P><P></P><P>I need with in one dimension first Manager data&nbsp; should come and then reportee information.</P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 424px; border-collapse: collapse;"><TBODY><TR style="height: 15pt;"><TD class="xl63" height="20" style="border: 0.5pt solid windowtext; width: 64pt; height: 15pt; background-color: #5b9bd5;" width="85"><STRONG style="font-family: Calibri;">Name</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: #5b9bd5;" width="64"><STRONG style="font-family: Calibri;">Q1 T</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: #5b9bd5;" width="64"><STRONG style="font-family: Calibri;">Q1 A</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 62pt; background-color: #5b9bd5;" width="83"><STRONG style="font-family: Calibri;">% age</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: #5b9bd5;" width="64"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Q2 T</STRONG></TD> <TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: #5b9bd5;" width="64"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Q2 A</STRONG></TD> </TR> <TR style="height: 15pt;"><TD class="xl64" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 15pt; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Manager</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Agg A</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Agg A</SPAN></TD> </TR> <TR style="height: 15pt;"> <TD class="xl66" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 15pt; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Reportee 1</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Rep T</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Rep A</SPAN></TD> <TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Rep T/Rep A</SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> </TR> <TR style="height: 15pt;"> <TD class="xl66" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 15pt; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Reportee 2</SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> <TD class="xl64" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #f2f2f2;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD> </TR> </TBODY></TABLE><P><BR /> </P></BODY></HTML> Wed, 24 Dec 2014 09:40:14 GMT https://community.qlik.com/t5/QlikView/Heirarchy-Report/m-p/785168#M277847 svsudhakar 2014-12-24T09:40:14Z Re: Heirarchy Report https://community.qlik.com/t5/QlikView/Heirarchy-Report/m-p/785169#M277848 <HTML><HEAD></HEAD><BODY><P>Either you need the managers and the reportees in the same dimension or you can try using a pivot table and enable the Indent option. </P></BODY></HTML> Wed, 24 Dec 2014 10:00:03 GMT https://community.qlik.com/t5/QlikView/Heirarchy-Report/m-p/785169#M277848 Gysbert_Wassenaar 2014-12-24T10:00:03Z