Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
ejacob
Contributor II
Contributor II

Expand all the dimensions - Pivot Table

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

5 Replies
SunilChauhan
Champion
Champion

presentation -> alloww fully expanded

is it working or not

Sunil Chauhan
ejacob
Contributor II
Contributor II
Author

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

Not applicable

Any help on this topic ?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable

How to do programmatically in VBScript to fully expand ?