Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot Table One Dimension Fully Expanded

I have a pivot table with 3 dimensions.  I'd like to have the first dimension always fully expanded, but not the two subsidiary dimensions.  Is this possible?  How?

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

It failed when pivot style is in "Indent Mode" (my version QlikView: 11.20.12904.0 SR12 64bit).

My workaround:

- expand/collapse nodes you want to save

- save bookmark

- Bookmarks --> More --> select bookmark you saved --> export bookmark

- open xml

- find "<ExpansionData>" node

- set manually <ElemNo><int> index of node expanded

In my presentation it work.