topic Fully expand pivot table but enable collapse in QlikView

Fully expand pivot table but enable collapse

Sun, 29 Jun 2014 19:00:32 GMT

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 ?

Re: Fully expand pivot table but enable collapse

Gysbert_Wassenaar — Mon, 30 Jun 2014 07:44:53 GMT

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

Re: Fully expand pivot table but enable collapse

stevedark — Mon, 30 Jun 2014 19:00:48 GMT

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