How to fix pivot table's wide ?

[#1]

Hi all,

When I use button "Fast change" to expand all columns of the pivot table, the wide is automatically increased and get out of the sheet's size.

How could I prevent that to happen ? (stupid question maybe but I'm new to Qlikview )

Thank you

[qv_jagan]

Go to style tab in pivot table properties and select indent mode. This should resolve your issue.

[Anonymous]

First go to Pivot table properties by right click on the chart. Then go to "layout" tab and unchecked the "size to data" in options section. And you have to size the chart manually.