Collapsing columns in a pivot table without Collapse All

Anonymous — Thu, 31 May 2012 14:16:23 GMT

Hi,

I have a pivot table with 6 dimensions and 1 expression column - the expression column is the rightmost column in the screenshot below:

The user wants the "Overdue" totals to be displayed immediately next to the "Management Line" column, when all the other columns in between (Region, Business Group 1, Business Group 2, Lead Analyst and Distribution) have been collapsed - they want this so that they don't have to scroll to the right to see the "Overdue" totals as it runs off the width of the screen. What they require can be achieved by right-clicking on the pivot table and selecting "Collapse All", like below:

However, the users want to be able to achieve the same thing without using the Collapse All option when you right-click in the pivot table. Is there a way to automatically "hide" columns which are not showing a value (they have values - they're just not being seen because the columns have been collapsed manually), without using "Collapse All"??

I think that perhaps this is just the way QlikView's was made, and it is just a matter of educating the user as to how QlikView works, but I would like clarification of this.

Many thanks,

Collapsing columns in a pivot table without Collapse All

Oleg_Troyansky — Thu, 31 May 2012 17:39:08 GMT

Not sure if this is going to help, but try experimenting with the "Indent Mode" (configured on the Style tab of the Pivot Table).

Re: Collapsing columns in a pivot table without Collapse All

Anonymous — Fri, 01 Jun 2012 08:30:20 GMT

Thank you for the suggestion, but enabling Indent Mode didn't work.

topic Collapsing columns in a pivot table without Collapse All in QlikView

Collapsing columns in a pivot table without Collapse All

Collapsing columns in a pivot table without Collapse All

Re: Collapsing columns in a pivot table without Collapse All