topic Re: Collapse all not working properly in pivot in QlikView

Collapse all not working properly in pivot

Anonymous — Wed, 29 Oct 2014 12:54:18 GMT

Collapse all only collapse rows of particular column.Is it possible to collapse all the rows of all columns in pivot

Thanks,

Kiran

Re: Collapse all not working properly in pivot

alexandros17 — Wed, 29 Oct 2014 12:55:29 GMT

go on the column name and then click collapse otherwise you collapse only the value on which you are

Re: Collapse all not working properly in pivot

danieloberbilli — Wed, 29 Oct 2014 12:58:04 GMT

have a look here:

Re: Collapse all not working properly in pivot

Anonymous — Wed, 29 Oct 2014 12:58:44 GMT

but this applied to individual column right?Is there any way to collapse all columns in single click.

Re: Collapse all not working properly in pivot

Anonymous — Wed, 29 Oct 2014 13:02:10 GMT

I dont want to remove functionality of collapse all.

Let me give more clear idea suppose I have 3 dimension in my pivot out of 1st 2 are expanded.

Now I want collapse all in single click is not get possible.

Is there any trick to do that

Re: Collapse all not working properly in pivot

Wed, 29 Oct 2014 13:06:38 GMT

Hi,

If you right click on first column and select collapse all then all the columns will collapse on single click.

Re: Collapse all not working properly in pivot

Wed, 29 Oct 2014 13:11:08 GMT

Hi,

Have a look at an example which I have created. I am giving snapshots of it.

Cheers

Saurabh

Re: Collapse all not working properly in pivot

alexandros17 — Wed, 29 Oct 2014 13:19:09 GMT

If you expand (as I told before) all the columns then you collapse on the first column each time you expand again it will automatically remember that all other columns are yet expanded

Let me know

Re: Collapse all not working properly in pivot

Anonymous — Wed, 29 Oct 2014 13:28:22 GMT

According to me it only collapse 1st column and hiding other columns.

When u again expand 1st column ,2nd column is allready in expanded state as it was previous before you do collapse all.

Re: Re: Collapse all not working properly in pivot

Wed, 29 Oct 2014 13:50:28 GMT

Hi Kiran,

It seems like only this is left-

1.Create the pivot table

2. Add a bookmark with "Include Layout State" option selected.

3. Collapse all the columns and create another bookmark with "Include Layout State" option selected.

4. Now, collapse and expand will take place with a single click without changing presentation tab settings.

Cheers

Saurabh