topic Re: How to fix pivot table's wide ? in QlikView

How to fix pivot table's wide ?

Mon, 14 Jul 2014 16:58:44 GMT

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

Re: How to fix pivot table's wide ?

Anonymous — Mon, 14 Jul 2014 18:07:05 GMT

in layout tab of the pivot table properties window, uncheck size to data (in Options section) and manually (drag the border of the chart) resize your chart window size to the required width. that should help.

Re: How to fix pivot table's wide ?

Tue, 15 Jul 2014 05:15:04 GMT

Hi,

I think jsaradhi is right first uncheck the Size to Data from Options In 'Layout Tab' then it you have to size it manually.

Thanks

Ankit

Re: How to fix pivot table's wide ?

Tue, 15 Jul 2014 06:42:53 GMT

Thank you both. Effectively I have this option checked. However I think it is used to increase the table'size (its height) when we have less or more data lines.

Now if I uncheck it, I will have a fixed height as well :-). I need to make a decision here...

Re: How to fix pivot table's wide ?

Tue, 15 Jul 2014 07:52:39 GMT

Hi,

With the above option you can manually set the height and width as well.When i am testing the same on my end its changing the width not height.

Thanks

Re: How to fix pivot table's wide ?

Colin-Albert — Tue, 15 Jul 2014 08:03:02 GMT

If you switch the design grid on, you will see the maximum size that the chart will being screen. You can then set the maximum width and height as you wish.

Re: How to fix pivot table's wide ?

Tue, 15 Jul 2014 12:17:52 GMT

Thank you Ankit. The problem is I would like a fixed width but a "fit to data" height ;-). I am going to try the hint of Colin, which is set the max size and leave the option "fit to data" checked

Re: How to fix pivot table's wide ?

Tue, 15 Jul 2014 12:19:25 GMT

Hi Colin, where exactly could I set the max width ? Is it possible to combine "fit to data" option with a max width ?

Re: How to fix pivot table's wide ?

Colin-Albert — Tue, 15 Jul 2014 20:45:45 GMT

With the Design Grid on, you can see the maximum size that the chart can expand into.

You cannot specify a width for each column you can just drag the column dividers to size.

You can enable the design grid from the View menu in QlikView Desktop.

Re: How to fix pivot table's wide ?

Fri, 18 Jul 2014 08:54:31 GMT

Hello, OK now I see the external box as in your image, and I tried to resize it to within the sheet's border. But when I used the Fast change button, the pivot table's width is getting out of the sheet's border again.

What should I do ?

Re: How to fix pivot table's wide ?

qv_jagan — Mon, 06 Mar 2017 14:39:54 GMT

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

Re: How to fix pivot table's wide ?

Anonymous — Mon, 23 Apr 2018 09:16:24 GMT

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.