Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

adjust of the columns Pivote Table

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

Thanks.

Tags (4)
5 Replies
Highlighted

Re: adjust of the columns Pivote Table

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!

Highlighted
Not applicable

Re: adjust of the columns Pivote Table

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.

Highlighted

Re: adjust of the columns Pivote Table

Hi

Try like this

Sheet properties-> Uncheck Move/size Sheet objects.

Its resolve that.

Note:

You can't able to move any objects.

Highlighted

Re: adjust of the columns Pivote Table

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!!!

Highlighted
Not applicable

Re: adjust of the columns Pivote Table

hi

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