topic Pivot table cell width resizes when collapsing or expanding in QlikView

Pivot table cell width resizes when collapsing or expanding

googel84 — Mon, 25 Oct 2010 18:42:46 GMT

Hi everyone, I'm facing a strange and singular problem with a pivot.

When you collapse a dimension, sometimes the relevant cell is resized to the minimal width possible, so that it become impossible to navigate the table unless you manually put the cell to the original size.

Instead, sometimes, it happens that you expand a node and the cell containing its sons loses its width and becomes as large as any other expression cell (I set them to be equally sized).

It's very strange and it's happening just for a few days. We are also facing performance problems because of new patches applied to the server by system administrator; could this behaviour be related to this kind of problem?

Before collapsing

After collapsing

Pivot table cell width resizes when collapsing or expanding

pover — Mon, 25 Oct 2010 20:34:47 GMT

I had the same problem in a project last year when using the indent mode. I never understood why and it might to be fixed in the version 10, but to fix it in that project, I had to do a right-click->expand all. Then I had to collapse one-by-one each group. Then I would save the file.

If I did a right-click->collapse all the text would be lost so I also had to tell the users to not use the collapse all function. Not a fun solution, but it worked.

Regards.

Pivot table cell width resizes when collapsing or expanding

rwunderlich — Mon, 25 Oct 2010 23:37:25 GMT

That's -- "Bug #33584: Indent Mode Pivot Table shows column short preventing you to read the field values" -- in SR6. The problem is not present in SR5 or QV10. Only workaround I know of is to resize each column individually.

-Rob