Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
javier_garcia_g
New Contributor III

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

Re: How hide a dimension or measure from the edition?

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

HidePrefix ‒ Qlik Sense

5 Replies
vasiliy_beshent
Contributor III

Re: How hide a dimension or measure from the edition?

Hello,

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

Try it.

javier_garcia_g
New Contributor III

Re: How hide a dimension or measure from the edition?

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

Re: How hide a dimension or measure from the edition?

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

HidePrefix ‒ Qlik Sense

javier_garcia_g
New Contributor III

Re: How hide a dimension or measure from the edition?

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
Contributor

Re: How hide a dimension or measure from the edition?

this is the better option

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