topic Re: Pivot table - how to collapse subsections in QlikView

Pivot table - how to collapse subsections

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

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

Re: Pivot table - how to collapse subsections

sinanozdemir — Thu, 22 Sep 2016 16:16:30 GMT

Hi,

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

Hope it helps.

Re: Pivot table - how to collapse subsections

Anonymous — Thu, 22 Sep 2016 18:00:02 GMT

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!

Re: Pivot table - how to collapse subsections

Digvijay_Singh — Thu, 22 Sep 2016 18:17:29 GMT

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.

Re: Pivot table - how to collapse subsections

Anonymous — Thu, 22 Sep 2016 18:33:13 GMT

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".

Re: Pivot table - how to collapse subsections

Anonymous — Thu, 22 Sep 2016 18:45:06 GMT

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!!

Re: Pivot table - how to collapse subsections

Anonymous — Thu, 22 Sep 2016 18:57:16 GMT

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.

Re: Pivot table - how to collapse subsections

Anonymous — Thu, 22 Sep 2016 18:58:09 GMT

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

Re: Pivot table - how to collapse subsections

Digvijay_Singh — Thu, 22 Sep 2016 19:07:55 GMT

Check this out, solution using bookmark and macro-

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

Re: Pivot table - how to collapse subsections

Digvijay_Singh — Thu, 22 Sep 2016 19:10:27 GMT

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

Re: Pivot table - how to collapse subsections

Digvijay_Singh — Thu, 22 Sep 2016 19:11:05 GMT

I mean in caption tab.

Re: Pivot table - how to collapse subsections

Anonymous — Thu, 22 Sep 2016 19:31:14 GMT

Wow! I didn't even notice you can slide your mouse there and drag the width !! I have been draggin the edge of the

object. I'm a newbie. I really am. Thanks for the tip.

Re: Pivot table - how to collapse subsections

Anonymous — Thu, 22 Sep 2016 19:32:59 GMT

Thanks for the link. I have to study this. I am not at the level where I jump in and start writing macros yet.