Fully expand pivot table but enable collapse

[#1]

A VBscript macro enables to create a Pivot Table. I use this line of code to have it fully expanded by default

props.TableProperties.PivotAlwaysFullyExpanded=true

However, then, the table cannot be collapsed anymore. How is it possible to Expand at creation, but still give the possibility to collapse it ?

[Gysbert_Wassenaar]

That's not possible without first setting PivotAlwaysFullyExpanded to false again.

[stevedark]

You have raised many questions regarding QlikView macros using VBScript.

The fact of the matter though is that you are far better designing your app so that Macros are not required.  Generally this can be achieved by training users how QlikView works natively - rather than trying to force it to do things in a way that is non-standard.

Henric Cronström did a post that states that Macros Are Bad - I suggest you give it a read.  http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/28/macros-are-bad

Regards,

Steve