topic Re: Pivot Table Hierarchy - one leaf shows expanded in QlikView

Pivot Table Hierarchy - one leaf shows expanded

Mon, 25 Nov 2013 10:11:45 GMT

Hi,

I've created a pivot table with a collapsed hierarchy. For some reason however, on of the top level elements shows all of the contained values even though it isn't expanded (still shows '+'). All the other top level elements are working as expected. If I click the '+' it changes to a '-' as if it was expanded, but with no other effect. Clicking again doesn't collapse it either:

Anyone else come across anything like this?

Thanks,

Rory.

Re: Pivot Table Hierarchy - one leaf shows expanded

marcohadiyanto — Mon, 25 Nov 2013 10:15:03 GMT

Dear Rory,

you can right click on your pivot table and then collapse all or expand all.

hope it helps

Re: Pivot Table Hierarchy - one leaf shows expanded

Mon, 25 Nov 2013 10:23:10 GMT

Thanks Marco - that solved it. I'll let my users know that solution in case they need to use it again in the future.

Thanks,

Rory.

Re: Pivot Table Hierarchy - one leaf shows expanded

Mon, 25 Nov 2013 10:31:25 GMT

Hi, check the always fully expanded option....Hope it will help

Hi try this........

Re: Pivot Table Hierarchy - one leaf shows expanded

Fri, 28 Feb 2014 17:59:45 GMT

Thank you!