Contract dimensions, pivot table

[#1]

Hello there, good day

I have a problem working with pivot table (and hierarchy selectors)

The fact is that when I clear the screen, clear all selectors etc, I want that the dimensions from the pivot table

and the levels from the Hierarchy selector get Contract, leave the table like when a activate the sheet,

i like to know if somebody can help me to do this, it could be with a macro to, but a actually don't know how it works like

I hope somebody can help me.

Thanks, and have a good Day

[Gysbert_Wassenaar]

If I understand you correctly you want to collapse all dimensions. Perhaps this discussion helps: Expand All/Collapse All

[#3]

Thank you for respond, I tried it but it doesn't work now, I read that it's for the version of Qlikview

[qlikviewwizard]

Please attach the sample file if possible. Tank you.

[#5]

Document

[#6]

Document