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?
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
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.
