topic Re: adjust of the columns Pivote Table in QlikView

adjust of the columns Pivote Table

Wed, 20 Nov 2013 17:38:10 GMT

Hello, I have a pivot table, in this table I need block the accion of adjust of the columns, how i do this ?

Thanks.

Re: adjust of the columns Pivote Table

Emmanuelle__Bustos — Thu, 21 Nov 2013 16:24:23 GMT

Hi Jesus

You need to go to Layout tab's Pivot Table and uncheck Allow Move/Size and Check Size to Data and additionally of you don't want to allow users to move the columns and Row order, go to Presentation tab and Uncheck Allow Pivoting.

Hope this helps!

Re: adjust of the columns Pivote Table

Thu, 21 Nov 2013 17:07:10 GMT

Hello Emmanuelle, I know you, I working in OpenTech, i does each point you mention but the pivot table uniformly increases width. When I increase width of one column, all columns increase.

Re: adjust of the columns Pivote Table

MayilVahanan — Thu, 21 Nov 2013 17:11:48 GMT

Try like this

Sheet properties-> Uncheck Move/size Sheet objects.

Its resolve that.

Note:

You can't able to move any objects.

Re: adjust of the columns Pivote Table

Emmanuelle__Bustos — Thu, 21 Nov 2013 17:32:04 GMT

Hi Jesus

As Mayil Vahanan Ramasamy commented but missed the tab name:

you have to go to Sheet properties-> Security-> User privilegies-> Uncheck Move/size Sheet objects.

But there a little detail with a bug:

63012

Columns still resizable in AJAX even after option to lock it is checked.

So you have to Upgrade QV Server to 11.2 SR4 to have this working and so this is solved.

I've already Test it and works.

Best Regards!!!

Re: adjust of the columns Pivote Table

Thu, 21 Nov 2013 17:39:18 GMT

Right clik on pivot--> properties--> layout tab --> uncheck the Size to data.