Is any button available for (Expand/Colapse All)

[#1]

I want simple button of 'Expand/Colapse All' on sheets.How can I add it???

(for qlikview version 11.2)

[Gysbert_Wassenaar]

There's no way to do that. Not with macro's, not with button actions. No way at all afaik.

[marcus_sommer]

Try this:

sub ExpandCollapseDimensions

set chart = ActiveDocument.GetSheetObject("CH21")

set gp = chart.GetProperties

gp.TableProperties.PivotAlwaysFullyExpanded = false'true

chart.SetProperties gp

end sub

- Marcus

[#4]

Thanks Marcus Sommer....

Tell me how can I use that script in Qlikview.

No any function of "ExpandCollapseDimensions'' in qlikview

[marcus_sommer]

Create a button, insert action, extern, execute macro and set the name from macro - ExpandCollapseDimensions. You could also it trigger by selection/change from fields/variables.

- Marcus

[#6]

thanks...

Its not collapse fully after clicking on button

[marcus_sommer]

ObjectID is changed?

set chart = ActiveDocument.GetSheetObject("YOUROBJECTID")