Color Change to select Field

[krishna20]

Hi Friends,

I'm having a scenario to change the color for selected values.E.g;

I Have a fields Participant and  Security

Participant Field                ;                Security Field   

A                                                             D

B                                                              E

C                                                              F

D                                                              G

                                                                 H

                                                                  I

                                                                  J

                                                                  K

The Both fields are related like above mentioned.

I'm taking both the fields in two straight tables with expressions.

When i select the value 'A' , in another table E,F,G will be shown. This E,F,G rows color should be changed dynamically and for another values also..

Is this possible???? If there is a technique ,how to achieve it.Please anyone can suggest me.

Regards

Krishna

[krishna20]

Hi Friends,

Any Idea !!

[stigchel]

Not quite sure what your exact requirements are, but you can use the background color expression of the expressions (and/or dimensions) you are using in the straight table. In the Expression tab, click on the plus sign of the expression, it will expand and there is a background color option. Here use something like (depending on your exact requirements)

if(GetSelectedCount(Participant)=1,if(Participant='A',rgb(255,0,0),rgb(0,255,0)))

To prevent having a very long nested if statement you could also load three fields e.g. R,G,B where you load the r,g,b values associated with your participant field and then use something like

if(GetSelectedCount(Participant)=1,rgb(R,G,B),rgb(0,255,0))

Hope that helps

[#4]

hii

you can change the background color of your expression

Check with this image