QlikView App Dev

[ejacob]

Is it possible to create a button to expand all the dimensions on the pivot table?
I've tried this

sub ExpandPivot
 on error resume next
 for n = 0 to 5 ' number of dimensions was 5
  set chart = ActiveDocument.GetSheetObject("CH01")
  chart.ExpandLeft 0, n, true
 next
end sub

but it doesn't work in Qlikview10

[IamBack]

presentation -> alloww fully expanded

is it working or not

[ejacob]

Explaining better...

I'd like to allow the application's users might search on the Pivot Table and if necessary, they could reset the search, expanding the chart with one clik on the button "Expand".

[#4]

Any help on this topic ?

[rwunderlich]

I know it's not a button, but they can right-click column headings and select Expand/Collapse All.

You may also want to consider using the method shown in this tutorial to toggle pivot table dimensions without using the +/-.

Qlikview Cookbook: Tutorial - About Column Visibility http://qlikviewcookbook.com/recipes/download-info/tutorial-about-column-visibility/

-Rob

[#6]

How to do programmatically in VBScript to fully expand ?