topic Re: Compress wholz pivot table at once in QlikView

Compress wholz pivot table at once

Tue, 12 Jun 2012 09:42:18 GMT

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

Re: Compress wholz pivot table at once

Miguel_Angel_Baeyens — Tue, 12 Jun 2012 09:47:53 GMT

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

Re: Compress wholz pivot table at once

Tue, 12 Jun 2012 09:50:55 GMT

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

Re: Compress wholz pivot table at once

Miguel_Angel_Baeyens — Tue, 12 Jun 2012 10:09:26 GMT

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.