Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you show us what you´ve already done and what you want to achieve?
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
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.
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)
I would try
=CalcDim($(vType).Colour)
for the Master item expression.
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.
@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?