topic Pivot Table Presentation Limitations? in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Presentation-Limitations/m-p/216707#M70006 <HTML><HEAD></HEAD><BODY><P>I found the full expand check box, oops!</P></BODY></HTML> Wed, 07 Jul 2010 15:28:22 GMT 2010-07-07T15:28:22Z Pivot Table Presentation Limitations? https://community.qlik.com/t5/QlikView/Pivot-Table-Presentation-Limitations/m-p/216706#M70005 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have taken in regular columns of data and using a pivot table come up with this format of table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 384pt; border-collapse: collapse;" width="512"><COLGROUP><COL span="8" style="width: 48pt;" width="64" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="background-color: transparent; width: 48pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="64">system</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64">warning</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64">critical</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64">jan</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64">feb</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64">mar</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64">apr</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64">jun</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">a</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">5</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">9</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">6</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">6</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">7</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">9</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">b</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">5</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">9</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">8</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">5</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">9</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">4</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">c</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">5</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">9</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">9</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">12</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">7</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">5</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">d</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">5</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">9</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">10</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">e</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">5</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">9</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">4</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">7</TD><TD class="xl22" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">7</TD></TR></TBODY></TABLE><BR /><BR /> <P>What I would like to know is.....Is there a way in which the table always remains fully expanded and also can the small minus icons on each cell(which enable you to minimise a field within the table) be turned off/removed in Qlikview? I would appreciate if anyone knew this yes/no answer.</P><P>Thanks,</P></BODY></HTML> Wed, 07 Jul 2010 15:22:59 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Presentation-Limitations/m-p/216706#M70005 2010-07-07T15:22:59Z Pivot Table Presentation Limitations? https://community.qlik.com/t5/QlikView/Pivot-Table-Presentation-Limitations/m-p/216707#M70006 <HTML><HEAD></HEAD><BODY><P>I found the full expand check box, oops!</P></BODY></HTML> Wed, 07 Jul 2010 15:28:22 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Presentation-Limitations/m-p/216707#M70006 2010-07-07T15:28:22Z