Discussion Board for collaboration related to QlikView App Development.
Hello, I have a pivot table, in this table I need block the accion of adjust of the columns, how i do this ?
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!
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.
Try like this
Sheet properties-> Uncheck Move/size Sheet objects.
Its resolve that.
You can't able to move any objects.
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:
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.
Right clik on pivot--> properties--> layout tab --> uncheck the Size to data.