Pivot table expansion options

[Anonymous]

Hi,

I am using a Pivot table in which what I am trying or looking for is User should be in a position to Collapse All rows and Expan all rows.Pivot table has an option in Presentaion tab with "Always fully expanded" but if user wants to see collapsed view then he should be in a position to collapse by clicking a button or something. Also I guess on right clicking the cell we get the option of collapse all and expand all but looking forward to have it button driven.

Any suggestions?

I have in my mind but not sure whether its a right approach. Create 2 different table one with "Always Fully Expanded" On and another one with "Always Fully Expanded" off and then drive both the tables using button actions.Wierd thought.

Please give your thoughts

Regards,

Swapnil

[johnw]

My suggestion? Don't create buttons. Don't set "always fully expanded". Let the user use pivot tables they way pivot tables are intended to be used. If they don't know how to expand and collapse, either teach them or put a short text explanation in the sheet itself. You're making a lot of work for yourself and doing your users a disservice if you keep them from learning how QlikView works by recoding basic QlikView controls manually as buttons.

Maybe I'm misunderstanding the question, though.

[Anonymous]

Hey John,a related question.....

Is it possible to lock the first few dimensions so that they can't be collapsed by the users while still allowing them to expand/collapse the right-most dimensions?

[johnw]

I'm not aware of a way. I just lead the users in that direction by expanding all of the dimensions except the last one. I figure they're unlikely to collapse the others, and if they do, they really intended to.

[Anonymous]

That's what I thought. I could have swore that I saw this capability in an earlier version (8.5 or 9) but maybe I'm thinking of something else.

[#6]

To achieve prevent collapsing of the "first few dimensions", could we concatenate these dimensions together into a single Calculated Dimension? I think that is a hacky way to achieve what you need, but I'm sure it has its downsides too...    

[#7]

I can see usefulness in "Expand All" and "Collapse All" -- I see them often in UI elements where users can navigate a hierarchy/tree (like a Pivot Table).

I think this user is asking a similar question.

Expand in pivot table

I know they're different, but I think PivotTable and "tree UI" can both express fixed-level (possibly unbalanced) hierarchies

Anyway, I guess conditional Conditional Dimensions , which could be controlled by Button clicks. But as John says you'd still need "Always Expanded" -- it's all or nothing.