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: 
Anonymous
Not applicable

Pivot table - how to collapse subsections

Hi,

I have been looking at the settings of the pivot chart but just can't seem to find the right

property/setting for this or how to configure this.  How do I collapse some of the dimensions of this sample screen?

qv7.jpg

For example, I want to collapse the "FiscalQuarter" and show a "+" sign.  When I click on the "+" sign, only then

expand the column to show all the possible quarters.  Same thing for the month.

Thanks

12 Replies
sinanozdemir
Specialist III
Specialist III

Hi,

Go to -> properties -> presentation tab and then make sure that "Always Fully Expanded" is unchecked:

Capture.PNG

Hope it helps.

Anonymous
Not applicable
Author

Yes, I did look at that before.  I wasn't being clear in my original post.  Can you selectively pick the dimension

you want to collapse/expand on?  Example, using my screenshot, can you do this on FiscalMonth column?  Meaning when chart is initially displayed, can I have the "+" on FiscalQuarter column?

The "always fully expanded" is either all or nothing operation.

Thanks!

Digvijay_Singh

If you right click on any dimension heading and select expand/collapse, it does for all values for that dimension only. Once it is done it keeps that setting even when we close and reopen the doc, not sure how it behaves in server environment. But for local docs its keeps the setting after initial setting made on which DIM to be collapsed or expanded while preparing the chart.

Anonymous
Not applicable
Author

Yes, I did notice this that QV seems to "remember" the last state.  However the above screenshot is a very simple one with only one year.  What if I have 2010, 2011 ... 2016?  Obviously it will more rows for the Quarter.  The more rows I have, the more combination of various states of the collapse/expand for the different dimensions.  So, next time when you open it, it really doesn't look that pretty and it doesn't have that consistent "look & feel".

Anonymous
Not applicable
Author

look and feel for pivot is either fully expanded or collapsed.. Not at intermediate states one expanded and one collapsed.

In QV, Document state can be remembered for user until application is next reloaded!!

Anonymous
Not applicable
Author

OK, a slightly different question on the pivot chart.  Currently I have four columns showing in my pivot chart.

I have manually expanded the width of this chart to show all 4 columns.  No problem.  But how I can expand the width slightly even wider so that it aligns with the width of another object above it?  If I try it, QV won't let me go further.

Anonymous
Not applicable
Author

Correction: actually it's not a pivot chart.  I want to do it on a Table Box.

Digvijay_Singh

Check this out, solution using bookmark and macro-

Re: expand only one field value in a pivot table (on open action)

Digvijay_Singh

Did you try using coordinates at the bottom of 'caption'?