It's possible to lock a dimension?

[tleivamo]

Hi everybody,

I want to know if is possible to lock any dimesion in a pivot table or a total chart.

I have some values and those are connected with other data, but i don't want them to get moved

Is it possible??

[Thiago_Justen_]

This may help you

Pivot Table Properties: Presentation ‒ QlikView

Allow Move Column and Pivoting

Deselect this check box to disable the drag-and-drop pivoting.

[tleivamo]

Hi Thiago,

Thanks for answer me. I work in qlik sense not qlik view. However, I was tried to find the option and I didn´t see it. Maybe in qlik sense doesn't exist. I wonder if that thing is possible...

Is there another option?

[devarasu07]

Hi,

yes we lock dimension value. have your tried like this?

[jonathandienst]

I think that locks the selection. I think the OP want to prevent the column from being moved. I don't know if that is possible in QS without an extension.

[Thiago_Justen_]

Check this out:

Scrolling

You can select to freeze the first column from horizontal scrolling.

https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/Visualizations/Table/table-pro...

Cheers

[Thiago_Justen_ · Accepted solution]

Note that according link above you can only freeze horizontal scrolling for the first column. If you want to prevent drag and drop columns, as Jonathan said, it os not possible in native QS's Tables.

[tleivamo]

Hi.

I tried all options but unfortunatelly nothing works. I believe that Thiago is right, it's no possible in native QS's Tables.

Thanks for try to help me.

Regards!.

[srilakshmi_as]

using sheet events extension we can pre lock it,but again usere  is able click unlock the lock..

which i s still an issue for me,any pointers kindly guide me