Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
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
Highlighted
Creator III
Creator III

Hello,

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

Try it.

Highlighted
Contributor III
Contributor III

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.

Highlighted
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

Highlighted
Contributor III
Contributor III

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.

Highlighted
Creator
Creator

this is the better option

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