topic Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/528894#M197723 <HTML><HEAD></HEAD><BODY><P>I want to create a pivot table made of the following excel spreadsheet attached.</P><P></P><P>When I select A1 i want to see the following pivot table:</P><TABLE border="1" class="jiveBorder" height="325" style="border: 1px solid #000000; width: 788px; height: 297px;" width="787"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Supports</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">2nd Level Supports</TH></TR><TR><TD style="padding: 2px;">A2</TD><TD style="padding: 2px;">A4</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">A1</TD></TR><TR><TD style="padding: 2px;">A3</TD><TD style="padding: 2px;">A4</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">A5</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">A6</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 27 Dec 2013 04:46:21 GMT 2013-12-27T04:46:21Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/528894#M197723 <HTML><HEAD></HEAD><BODY><P>I want to create a pivot table made of the following excel spreadsheet attached.</P><P></P><P>When I select A1 i want to see the following pivot table:</P><TABLE border="1" class="jiveBorder" height="325" style="border: 1px solid #000000; width: 788px; height: 297px;" width="787"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Supports</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">2nd Level Supports</TH></TR><TR><TD style="padding: 2px;">A2</TD><TD style="padding: 2px;">A4</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">A1</TD></TR><TR><TD style="padding: 2px;">A3</TD><TD style="padding: 2px;">A4</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">A5</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">A6</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 27 Dec 2013 04:46:21 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/528894#M197723 2013-12-27T04:46:21Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/528895#M197724 <HTML><HEAD></HEAD><BODY><P>You need to use the Hierarchy statements in the script.</P><P></P><P>See the attached for a simple example.</P><P></P><P>The below link is a great resource to get Hierarchies integrated properly into your application.</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4823">http://community.qlik.com/docs/DOC-4823</A></P></BODY></HTML> Fri, 27 Dec 2013 06:16:02 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/528895#M197724 Anonymous 2013-12-27T06:16:02Z