topic Re: Expand all the dimensions - Pivot Table in QlikView

Expand all the dimensions - Pivot Table

ejacob — Tue, 20 Sep 2011 14:58:13 GMT

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

Expand all the dimensions - Pivot Table

SunilChauhan — Tue, 20 Sep 2011 15:56:47 GMT

presentation -> alloww fully expanded

is it working or not

Expand all the dimensions - Pivot Table

ejacob — Tue, 20 Sep 2011 18:03:21 GMT

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

Re: Expand all the dimensions - Pivot Table

Sat, 28 Jun 2014 17:58:57 GMT

Any help on this topic ?

Re: Expand all the dimensions - Pivot Table

rwunderlich — Sat, 28 Jun 2014 22:03:36 GMT

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

Re: Expand all the dimensions - Pivot Table

Sun, 29 Jun 2014 13:51:07 GMT

How to do programmatically in VBScript to fully expand ?