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