how to show label for calculated dimension in search bar - currently shows the expression

[wizardo]

hi, i have a calculated dimension

i can use the label option for it and in the visualization (table) it shows the label i gave it

but when the user selects a value in this dimension, up in the bar it shows as not the label but the expression.

in previous posts, i read that i need to make it a master item dimension, but it didn't help

any ideas?

i have seen many posts about it, but none with a solution

any ideas?:)

Daniel

[rubenmarin]

Hi Daniel, using a master item dimension it should show the "name" of the item. I have tested it now in a september-2018 version.

[Clever_Anjos]

Could you show us what you´ve already done and what you want to achieve?

[wizardo]

hmm

this is so strange

i have November version

and in fact, this (using a master item) works sometimes

and sometimes it doesn't work.

i am still experimenting trying to figure out when it works and when not but its very strange

for example, it works in few models and doesn't work in others

sometimes it doesn't work if i first used the calculated dimension inside a chart and only after i moved it to a master item.

ill update if i find some regularity on when it happens and when not 

[rnorris]

Yeah, we've got the November 2021 version of Qlik Sense. I cannot make a master dimension show anything other than the expression in the current selections. It is maddening. 

[E_Røse]

@rnorris , try

=CalcDim(YourExpression)

[rnorris]

Sorry, I don't follow? Can you give me an example of what goes where with that? 

Lets say I have a master dimension with a formula of =$(vType).Colour

That can show different fields depending on what the variable is set to.

As the Master Dimension Label I put ='Colour'.

It will always show EXPANSIONOFvTYPE.Colour in the selection box.

How are you suggesting I change this? 

/Edit: Or, that's a bit racy, rather than doing that, lets just say I have a master Dimension that is:

=if(Content = 'Something', 1, 0)

And I give it a name of TEST

And a label of ='Content Test'

Whatever I select, in the current selections, it will always show up as

=if(Content = 'Something', 1, 0)

[E_Røse]

I would try 

=CalcDim($(vType).Colour)

for the Master item expression.

[barnabyd]

G'day Everyone,

If it's possible, it is much better to perform the calculation in the load script. Your app will be more efficient for the users and you don't need a calculated dimension.

Cheers, Barnaby.

[E_Røse]

@rnorris, I did some more testing, try to remove the label completely from the Master Item, and just use the Name Colour  for the master dimension. Do not use the CalcDim as I suggested before.

Is that working for you?