Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Expand dimension in a pivot table using macro in Qlikview 11

Hi,

I would like to create a macro to expand or collapse a specific dimension in a pivot table. I noticed others questioned this as well but did not see an answer for Qlikview 11. Apparently in Qlikview 8 it could be done the following way:

sub CollapsePivot

set chart = ActiveDocument.GetSheetObject("CH01")
chart.CollapseLeft 0,0,true
end sub

Is there an equivalent in Qlikview 11?

Thanks

-Thomas

Community Browser