Pivot Table Display Problem

[anthony_kinsell]

Hi,

I'm relatively new to Qlikview & am having sporadic issues using a pivot table. When I try collapse some rows the icon changes from - to + but the data remains visable.

What causes this to happen & how can it be corrected?

[MayilVahanan]

HI

Check in Presentation -> Always fully expanded is checked or not?, if checked, uncheck it.

[anthony_kinsell]

Hi,

No it’s not checked – that’s what’s really odd about it, some of the rows do collapse as you’d expect & some don’t.

[MayilVahanan]

Hi

Please create one another chart like tat.. and check it

[anthony_kinsell]

I have numerous charts like this one – happened once on another one but seems to fix itself when I reloaded the data.

Hasn’t happened since until with this chart today

[anthony_kinsell · Accepted solution]

Figured out the answer.

When I right click on the pivot table & select 'Fit Columns to Data' I then get the option to collapse all which was previously greyed out.