topic Is any button available for (Expand/Colapse All) in QlikView

Is any button available for (Expand/Colapse All)

Thu, 23 May 2013 11:43:32 GMT

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

(for qlikview version 11.2)

Re: Is any button available for (Expand/Colapse All)

Gysbert_Wassenaar — Thu, 23 May 2013 11:46:51 GMT

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

Re: Is any button available for (Expand/Colapse All)

marcus_sommer — Thu, 23 May 2013 12:27:00 GMT

Try this:

sub ExpandCollapseDimensions

set chart = ActiveDocument.GetSheetObject("CH21")

set gp = chart.GetProperties

gp.TableProperties.PivotAlwaysFullyExpanded = false'true

chart.SetProperties gp

end sub

- Marcus

Re: Is any button available for (Expand/Colapse All)

Thu, 23 May 2013 12:36:37 GMT

Thanks Marcus Sommer....

Tell me how can I use that script in Qlikview.

No any function of "ExpandCollapseDimensions'' in qlikview

Re: Is any button available for (Expand/Colapse All)

marcus_sommer — Thu, 23 May 2013 12:46:22 GMT

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

Re: Is any button available for (Expand/Colapse All)

Thu, 23 May 2013 13:28:28 GMT

thanks...

Its not collapse fully after clicking on button

Re: Is any button available for (Expand/Colapse All)

marcus_sommer — Thu, 23 May 2013 14:42:56 GMT

ObjectID is changed?

set chart = ActiveDocument.GetSheetObject("YOUROBJECTID")