Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tleivamo
New Contributor II

It's possible to lock a dimension?

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

1 Solution

Accepted Solutions
thiago_justen
Valued Contributor III

Re: It's possible to lock a dimension?

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.

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
7 Replies
thiago_justen
Valued Contributor III

Re: It's possible to lock a dimension?

This may help you

Pivot Table Properties: Presentation ‒ QlikView

Allow Move Column and PivotingDeselect this check box to disable the drag-and-drop pivoting.
Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
tleivamo
New Contributor II

Re: It's possible to lock a dimension?

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
Honored Contributor II

Re: It's possible to lock a dimension?

Hi,

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

lock selection.jpg

MVP
MVP

Re: It's possible to lock a dimension?

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
Valued Contributor III

Re: It's possible to lock a dimension?

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 Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
thiago_justen
Valued Contributor III

Re: It's possible to lock a dimension?

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.

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
tleivamo
New Contributor II

Re: It's possible to lock a dimension?

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