Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Qlik Launches Open Lakehouse and advanced agentic AI experience in Qlik Answers! | LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies