topic Pivot Table Expand/Collapse in QlikView

Pivot Table Expand/Collapse

Sat, 20 Jun 2009 01:28:29 GMT

I have a Qlikview dashboard with a pivot table fully expanded. The dashboard would collapse when a macro runs for one user and function normally for everyone else. The normal or expected function is to have the table stay fully expanded after the macro runs. Does anyone know why this would happen and how to fix it?

Pivot Table Expand/Collapse

Sat, 20 Jun 2009 02:58:20 GMT

Try to use PivotAlwaysFullyExpanded in the macro attached is the example from the API guide

set chart = ActiveDocument.Activesheet.CreatePivotTable
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
chart.AddExpression "count(Customer)"
set gp = chart.GetProperties
gp.TableProperties.PivotAlwaysFullyExpanded = true
chart.SetProperties gp

Talha

Pivot Table Expand/Collapse

Sat, 20 Jun 2009 03:08:23 GMT

If I set to always fully expand, would that disable the expand/collapse function? I do not want to disable that ability, i just don't want the table to automatically collapse the table.