Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How hide a dimension or measure from the edition?

Hi!

I would like hide the dimension or measure of the menu of a chart edition.

I want that only several columns of the tables was available to choose there.

For example, of a table I want see to choose the "name" but I don't want have the option of take "idName".

pregunta qlik.png

I add a image to show where I want hide the columns of the table.

In this case I want hide the colums if the ids.

Someone knows how I can do it?

Thanks and regards.

1 Solution

Accepted Solutions
ehilsinger
Contributor III
Contributor III

How about using the HidePrefix?  Your dimension name would have to change though.

HidePrefix ‒ Qlik Sense

View solution in original post

5 Replies
Vasiliy_Beshentsev
Creator III
Creator III

Hello,

the only way to hide is to comment this field(dimension) by "//" in scrypt.

Try it.

Anonymous
Not applicable
Author

Hello.

If you comment the field in the script, the field will be unselected, but the relation with others tables will be broken.

So it is like field don't exist.

I want that field exist, and that have relations with others tables, but I would like hide it/them of the possibilities of choice of the charts.

Thanks by the answer.

Regards.

ehilsinger
Contributor III
Contributor III

How about using the HidePrefix?  Your dimension name would have to change though.

HidePrefix ‒ Qlik Sense

Anonymous
Not applicable
Author

Thank you so much. I tried this and work. Only I wanted ask you which way is the best.


---------------------------------------------------------------

set HidePrefix='_' ;


[TABLE]:

LOAD

[id],

[idTiempo] AS [_TABLE.idTiempo], <-- This

[idProducto],

[idConcepto],

[idUnidad] AS _[TABLE.idUnidad], <-- Or this

[valor] AS [TABLE.valor];

---------------------------------------------------------------

Thanks again.

vangurideepu
Creator
Creator

this is the better option

[idUnidad] AS _[TABLE.idUnidad], <-- Or this