Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.