topic Multiple Hierarchy pivot table in QlikView

topic Multiple Hierarchy pivot table in QlikView https://community.qlik.com/t5/QlikView/Multiple-Hierarchy-pivot-table/m-p/401260#M562620 <HTML><HEAD></HEAD><BODY><P>Looking to set up hierarchies in the below format on the X-axis and Y-axis in a pivot table, can you give me any idea how to proceed?</P><P>Have bought my hierarchies into the table but not sure how to set them up on Business line with drilldown for both the hierarchies.</P><P></P><P>Appreciate any ideas you can ptich in.</P><P></P><P>Thanks</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 4</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 5</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 6</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 8</STRONG></SPAN></TH></TR><TR><TD>  Business    </TD><TD>ABC</TD><TD><BR /></TD><TD>FGH</TD><TD><BR /></TD><TD>MNO</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD>BC</TD><TD><BR /></TD><TD>GH</TD><TD><BR /></TD><TD>NO</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD>C</TD><TD><BR /></TD><TD>H</TD><TD><BR /></TD><TD>O</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD>sales</TD><TD>predictions</TD><TD>sales</TD><TD>predictions</TD><TD>sales </TD><TD>predictions</TD></TR><TR><TD>Accounts</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>wxyz</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>xyz</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>yz</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>z</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>ghjk</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>hjk</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>jk</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>k</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE></BODY></HTML> Sun, 03 Mar 2013 23:22:44 GMT 2013-03-03T23:22:44Z Multiple Hierarchy pivot table https://community.qlik.com/t5/QlikView/Multiple-Hierarchy-pivot-table/m-p/401260#M562620 <HTML><HEAD></HEAD><BODY><P>Looking to set up hierarchies in the below format on the X-axis and Y-axis in a pivot table, can you give me any idea how to proceed?</P><P>Have bought my hierarchies into the table but not sure how to set them up on Business line with drilldown for both the hierarchies.</P><P></P><P>Appreciate any ideas you can ptich in.</P><P></P><P>Thanks</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 4</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 5</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 6</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 8</STRONG></SPAN></TH></TR><TR><TD>  Business    </TD><TD>ABC</TD><TD><BR /></TD><TD>FGH</TD><TD><BR /></TD><TD>MNO</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD>BC</TD><TD><BR /></TD><TD>GH</TD><TD><BR /></TD><TD>NO</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD>C</TD><TD><BR /></TD><TD>H</TD><TD><BR /></TD><TD>O</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD>sales</TD><TD>predictions</TD><TD>sales</TD><TD>predictions</TD><TD>sales </TD><TD>predictions</TD></TR><TR><TD>Accounts</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>wxyz</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>xyz</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>yz</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>z</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>ghjk</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>hjk</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>jk</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>k</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE></BODY></HTML> Sun, 03 Mar 2013 23:22:44 GMT https://community.qlik.com/t5/QlikView/Multiple-Hierarchy-pivot-table/m-p/401260#M562620 2013-03-03T23:22:44Z