topic Re: Pivot Table with some rows expanded and others not in QlikView

Pivot Table with some rows expanded and others not

Anonymous — Tue, 11 Feb 2014 06:24:50 GMT

I am having an issue with a pivot table. When the page is loaded on server, for some rows, it is expanded as shown in the prinstcreen "DOA not showing.png". Even though it is fully expanded, The + sign is still displaying. I would like to have the pivot table expansions to be collapsed on loading. The properties "show as fully expanded" is already unselected for the pivot table.

I would like to know if it is possible to solve this issue.

Kindly advise

Thanks

Hasnaa

Re: Pivot Table with some rows expanded and others not

rahulgupta — Tue, 11 Feb 2014 06:44:59 GMT

Hi Hasnaa,

For this i didnt completely understood your issue, but still you can save the published app from the Qlikview desktop by doing the pivot fully collapsed. So that it always be collapsed at the loaded time for the user.....

Hope this helps..

Regards

Rahul

Re: Pivot Table with some rows expanded and others not

Tue, 30 Sep 2014 13:21:42 GMT

I have the same issue...
QV file not yet published.. Working with client 11.2

Re: Pivot Table with some rows expanded and others not

PrashantSangle — Tue, 30 Sep 2014 13:23:12 GMT

Hi,

Select Always Fully expanded from Presentation tab.

Regards

Re: Pivot Table with some rows expanded and others not

Tue, 30 Sep 2014 13:30:13 GMT

Thanks for your reply

My problem is that I don't want to set the report as Fully Expanded.
When rows are collapsed I can read some furhter details.

I.e: Dimensions: Sold_to, Ship_to, Material

If I cange dimensions in layout I have same issue and always for same customers

thanks

Re: Pivot Table with some rows expanded and others not

mjayachandran — Tue, 30 Sep 2014 13:33:56 GMT

In you chart properties 'Presentation' tab,

Check "Always fully expanded"

Re: Pivot Table with some rows expanded and others not

Tue, 30 Sep 2014 13:35:33 GMT

It's not flagged

Re: Pivot Table with some rows expanded and others not

Colin-Albert — Tue, 30 Sep 2014 13:40:08 GMT

Right-Click on each column header, starting with the furthest on the right, and select Collapse All until you have the chart showing as you want, then save the app.

Re: Pivot Table with some rows expanded and others not

Tue, 30 Sep 2014 13:48:14 GMT

Perfect!

Thanks a lot, not it works.

I really don't understand why it was happening always to same customers, even changing layout...

thanks

Re: Pivot Table with some rows expanded and others not

Colin-Albert — Tue, 30 Sep 2014 13:51:24 GMT

When you click and collapse a higher level column in a pivot table, QlikView seems to store the level at which the underlying columns are expanded, so when you click to expand one column, sometimes more than one column will expand.

You can reset this by collapsing each column individually.