Color dispappears when Master Dimension containing a variable is used in line chart

[anuhegde]

Hi all,

I have a line chart and the dimension used in Country. It is a master dimension.It contains a variable vCountry which is nothing but the country field. The color property is set to color by dimension but the color appears to be gray. I edited the master dimension,removed the variable $(vCountry) and directly used the Country field. The color appeared.

Any idea why does the color turns to gray when variable is used?

Thanks in advance

Anusha

[YoussefBelloum]

Hi,

did you try using the same variable when you put color as expression ?

[anuhegde]

Hi,

Yes. I did. It is still gray

[praveenkumar_ma]

Hi Anusha,

Try giving Column Name , Instead of Expression at the Place of Color Expression ..

Regards

PM

[avinashelite]

Hi Anusha,

your variable should evaluate to the dimension name...I think your evaluating at the dim level ? could give your variable definition also

[anuhegde]

Hi Avinash,

Sure

Variable name: vCountry

Definition: Country

In the master Dimension: =$(vCountry)

[avinashelite]

do you have calculation here ? because if you just have the dim name you could directly use it rite? why the need of variable

[praveenkumar_ma]

You Can try this as Color Expression

='$(vCountry)'

[anuhegde]

We use variables in most of the places. They are created in an excel file and this excel file will be loaded to the application.

no calculation

[anuhegde · Accepted solution]

This seems to be working.

I changed the definition of variable to [Country] from Country and the color appears.

Don't understand how it makes a difference.