Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
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
end sub

but it doesn't work in Qlikview10

5 Replies

presentation -> alloww fully expanded

is it working or not

Sunil Chauhan
Contributor II
Contributor II

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 ?


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


Not applicable

How to do programmatically in VBScript to fully expand ?