Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
gloria_bertini
Creator
Creator

Dimension not selectable

Hi Everybody,

Is there a way, in qlik sense, to make a dimension not selectable in a pivot table ?

Thank in advice

1 Solution

Accepted Solutions
agigliotti
MVP
MVP

No Gloria, you can't.

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

View solution in original post

3 Replies
agigliotti
MVP
MVP

No Gloria, you can't.

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
gloria_bertini
Creator
Creator
Author

ok, thanks for the reply

AnthonyM
Contributor II
Contributor II

If anyone is still looking for an option to make dimension unselectable (for example in the table):

1. Create an alternate state in master items: i.e. NewState1
2. Edit the table that you want to have dimensions unselectable and go to alternate states --> change to your NewState1
3. Use set analysis in the measures in this table to ensure these are referring to the default state, not NewState1 by adding {$} to the expression like that: Sum({$}Measure).

As a result it is still technically possible to click and select the dimensions in this table, but it won't have any effect as no other objects are using this alternate state, and measures in this object are referring to default state {$}.
If you want to just make one of the columns/dimensions unselectable that solution won't work.