Expand/Collapse Pivot Table using a Macro

Wed, 24 Mar 2010 12:40:08 GMT

Hi everyone

The command PivotAlwaysFullyExpanded works well for expanding a Pivot Table completely, but when collapsing the table, it can only collapse it down to the previous manual selection of [+] and [-]. I can't find any equivalent commands for collapsing tables.

Example using PivotAlwaysFullyExpanded for expanding/collapsing a table with one button:

sub CollapseExpandPivot

set chart = ActiveDocument.GetSheetObject("CH01")

set gp = chart.GetProperties not gp.TableProperties.PivotAlwaysFullyExpanded

end sub

How do i fully collapse a Pivot Table with multiple dimensions using a macro?

Best regards

Frederik

Expand/Collapse Pivot Table using a Macro

Fri, 26 Mar 2010 14:42:28 GMT

This type of function seemed to be commonly used until 9.0, where it was changed.

Are there really no one who have a solution for 9.0?

topic Expand/Collapse Pivot Table using a Macro in QlikView

Expand/Collapse Pivot Table using a Macro

Expand/Collapse Pivot Table using a Macro