How to collapse all dimensions?

[Anonymous]

Hi,

I have pivot chart that looks like this.  QV seems to remember the last "state" I was in. 

My question is how do I collapse all the dimensions back to the "FiscalYear" level (see 2nd screenshot)

every time I click on this sheet?  I don't want the "state: to be remembered.

Thank you.

[rupamjyotidas]

It will only clear the state of your app. not the other Users. If they want, they need to do the same every time they log in.

You can also change the server settings , so that it doesn't save any state

[Anonymous]

I prefer the solution to be on the client side vs. backend.  So if there's some type of macro (or code) to do this, this would ideal for me.

[Anonymous]

I've spent a couple of hours researching for a solution, it does not appear QV can do what I'm asking.  I saw this same question being asked a few years back on this forum.  If anyone has written a macro (or code) to mimmick right click on chart header -> Collapse All, please post.

Thanks!

[Anonymous]

Does this help you?

[Anil_Babu_Samineni]

I don't think so Qlikview has this future. But, gurus or supported emp's can help us

[Anonymous]

Hi Marcio,

Thanks for sharing the code.  Unfortunately this isn't exactly what I was looking for.  It's a nice piece of coding

for hiding/unhiding everything.

[Anonymous]

I'm sorry, the intention was to really help.

[Peter_Cammaert]

Define a bookmark for a collapsed pivot. Include the layout state, but do not include any selections.

Load this bookmark by triggereing an action everytime you enter the sheet.

[Anonymous]

Peter,

That's exactly what I was playing around with yesterday.  I had it working but realized I ended up having two buttons per chart.  One button to expand and another to collapse.  I didn't like having 4 buttons occupying the screen just to do this.  I'd rather ask the users to right click on the chart -> click expand/collapse.

[Peter_Cammaert]

You can reduce the number of buttons by setting a variable when applying each of two bookmarks (expand/collapse) and hiding "the other" button. If you put them in the same place, the use of these buttons will be intuitive.

To make it more clear what state is currently displayed, and what the button will do, you can design it with a plus sign or a minus sign in the center.