Condition in dimension

[jose_vargas]

Hi.

I want to aplicate a condition in a dimension. My case is:

I have a graphic with some cod of location: 4,5,6,7,8,9 and 10.   and the code i used is:   =if(Cod_Localizacion>=4 and Cod_Localizacion<=10,Desc_Localizacion)

That is perfect!!!.. Its work

I have a dimension, the values for default is:

• desarrolloti
• helpdesk
• none
• sysadmin

But i need to filter the dimension and show only the values that belong at cod of location.

If i used in dimension the value "expression" its work.

BUT, when i select some values of this dimension, dont show the green color, i select the value but no show color of selection. I think is because you can not use other different variables that dimension, in my case my dimension is "Cod_AreaResponsable" and i use condition with "Cod_Localizacion"

Please help me!!, what should i do to work correctly???

[jose_vargas]

Hi..

Someone there who solved this problem?? i try everything and not works...

[Anonymous]

Hi,

have you try to create a new field in script based on your expression "if(Cod_Localizacion>=4 and Cod_Localizacion<=10,Cod_AreaResponsable)" to get one variable on your list box.

Regards