Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Compress wholz pivot table at once

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

Tags (1)
3 Replies

Re: Compress wholz pivot table at once

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

Re: Compress wholz pivot table at once

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

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.

Community Browser