Pivot table grid data and column should be disable when user try to drag a column

[#1]

hello ,

in pivot table , in spite of unchecking the ALLOW MOVING / ALLOW Copying option  at documents section , users can dragged a column and make it haphazard .

what should we do to prevent this ?

should we uncheck this Option ( Allow moving / Allow copying option ) at management console under SYSTEM->Setup

click on qlikview server , right pane <Document tab> under object.. uncheck this option..

on doing , this , will this issue be resolved.

please advise.

Many Thanks

donesh

[stigchel · Accepted solution]

Hi Donesh,

In the properties\presentation tab uncheck allow pivoting

[Colin-Albert]

The Allow Moving and Allow Copying options relate to moving the whole chart on the sheet and copying the whole chart to another chart or application.

To prevent moving of columns within the pivot chart, you need to untick the "Allow Pivoting" option on the Presentation sheet as suggested by Piet.