topic Re: Pivot Table with more than one dimension in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-with-more-than-one-dimension/m-p/327215#M581309 <HTML><HEAD></HEAD><BODY><P>I think you're asking for this?</P><P></P><P style="padding-left: 30px;">Properties -&gt; Presentation -&gt; Always Fully Expanded</P></BODY></HTML> Wed, 28 Dec 2011 16:56:22 GMT johnw 2011-12-28T16:56:22Z Pivot Table with more than one dimension https://community.qlik.com/t5/QlikView/Pivot-Table-with-more-than-one-dimension/m-p/327214#M581308 <HTML><HEAD></HEAD><BODY><P>In a pivot table with several dimensions it is automatically possible to show different levels of detail by clicking on the + or - signs.</P><P></P><P>Is it possible to deactivate this option?</P><P></P><P>Our data would always need to be visualised showing the highest level of detail, subtotals or sums don't make any sense in this case.</P><P></P><P>Unfortunately using a standard table is not the solution (Crosstable was used to load the data and pivot to switch from rows to columns). Also tried to utilize just one dimension in combination with several formulas instead of several dimensions plus one formula but then the data is not shown correctly.</P><P></P><P>Are there any alternatives? Thank you very much in advance!</P></BODY></HTML> Wed, 28 Dec 2011 15:49:33 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-with-more-than-one-dimension/m-p/327214#M581308 2011-12-28T15:49:33Z Re: Pivot Table with more than one dimension https://community.qlik.com/t5/QlikView/Pivot-Table-with-more-than-one-dimension/m-p/327215#M581309 <HTML><HEAD></HEAD><BODY><P>I think you're asking for this?</P><P></P><P style="padding-left: 30px;">Properties -&gt; Presentation -&gt; Always Fully Expanded</P></BODY></HTML> Wed, 28 Dec 2011 16:56:22 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-with-more-than-one-dimension/m-p/327215#M581309 johnw 2011-12-28T16:56:22Z Pivot Table with more than one dimension https://community.qlik.com/t5/QlikView/Pivot-Table-with-more-than-one-dimension/m-p/327216#M581310 <HTML><HEAD></HEAD><BODY><P>Brilliant, thank you !!!!</P></BODY></HTML> Wed, 28 Dec 2011 17:00:44 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-with-more-than-one-dimension/m-p/327216#M581310 2011-12-28T17:00:44Z