Selection shows calculation in dimension

[shephali23]

When using formula in dimension, upon selection of the dimension, the selection area shows the formula.

How can it be changed to not show the formula rather the individual component of formula? Using a master dimension solves this but looking for alternatives where in I dont have to create a master dimension or change the formula

[dplr-rn]

master dimension is the only way afik

[albertovarela]

or load the calculated dimension via the data load editor or data manager.

[Vegar]

Some expressions can be hidden by creating a dimension front end. 

As an example the dimesion expression below will display as just Username when a selection is done.

=aggr( if(
left(only({1}[Admin_type]),3)='Adm', only({1}Username)), Username)

(I believe it is the Aggr() by dimension that is the key of this behaviour)

[jaimeaguilar]

Hi,

Using aggr() for your calculated dimension will definitely hide the expression/formula. For example if your calculated dimension is something like  --> if(field1 = 'A', 'value1', 'value2'), then you just have to enclose your original expression with aggr and use your original dimension as your sort/summarize field:

aggr( if(field1 = 'A', 'value1', 'value2'), field1) so Qlik sense will perform an indirect selection. In other words, every time you make a selection in your calculated dimension, you'll see field1 values in the selections bar, instead of the calculated dimension.

You can check the attached example for your reference,

I hope this helps