topic Re: Pivot Table One Dimension Fully Expanded in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-One-Dimension-Fully-Expanded/m-p/402287#M1149320 <HTML><HEAD></HEAD><BODY><P>Manually expand the first dimension and save the document and never expand any other dimension again. That's the only way. No other way exists. Not with button actions, not with macro's.</P></BODY></HTML> Thu, 23 May 2013 18:20:49 GMT Gysbert_Wassenaar 2013-05-23T18:20:49Z Pivot Table One Dimension Fully Expanded https://community.qlik.com/t5/QlikView/Pivot-Table-One-Dimension-Fully-Expanded/m-p/402286#M1149319 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with 3 dimensions.&nbsp; I'd like to have the first dimension always fully expanded, but not the two subsidiary dimensions.&nbsp; Is this possible?&nbsp; How?</P></BODY></HTML> Thu, 23 May 2013 18:01:48 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-One-Dimension-Fully-Expanded/m-p/402286#M1149319 Anonymous 2013-05-23T18:01:48Z Re: Pivot Table One Dimension Fully Expanded https://community.qlik.com/t5/QlikView/Pivot-Table-One-Dimension-Fully-Expanded/m-p/402287#M1149320 <HTML><HEAD></HEAD><BODY><P>Manually expand the first dimension and save the document and never expand any other dimension again. That's the only way. No other way exists. Not with button actions, not with macro's.</P></BODY></HTML> Thu, 23 May 2013 18:20:49 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-One-Dimension-Fully-Expanded/m-p/402287#M1149320 Gysbert_Wassenaar 2013-05-23T18:20:49Z Re: Pivot Table One Dimension Fully Expanded https://community.qlik.com/t5/QlikView/Pivot-Table-One-Dimension-Fully-Expanded/m-p/402288#M1149321 <HTML><HEAD></HEAD><BODY><P>It failed when pivot style is in "Indent Mode" (my version QlikView: 11.20.12904.0 SR12 64bit).</P><P></P><P>My workaround:</P><P>- expand/collapse nodes you want to save</P><P>- save bookmark</P><P>- Bookmarks --&gt; More --&gt; select bookmark you saved --&gt; export bookmark</P><P>- open xml</P><P>- find "&lt;ExpansionData&gt;" node </P><P>- set manually &lt;ElemNo&gt;&lt;int&gt; index of node expanded</P><P></P><P>In my presentation it work.</P></BODY></HTML> Tue, 07 Mar 2017 08:51:30 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-One-Dimension-Fully-Expanded/m-p/402288#M1149321 2017-03-07T08:51:30Z