Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compress wholz pivot table at once

Hi guys is there a way to compress the whole pivot table at once?

3 Replies
Miguel_Angel_Baeyens

Hi,

First go to the chart properties, Presentation tab and make sure that "Always Fully Expanded" is unchecked. Then right click on the first dimension [+] sign and select "Collapse All". That should do.

Hope that helps.

Miguel

Not applicable
Author

i mean when i am viewing the report, is there a way to implement a button which has that function? without having to go to properties

Miguel_Angel_Baeyens

Hi,

Check the APIGuide.qvw file for the class ITableProperties. I guess there's a way to do it via macro, although I don't recommend to do that way should there is some API to do it.

Regards.

Miguel

EDIT: John Witherspoon wisely explained here how he achieved something like that without using macros. I think it's worth taking a look.