Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Friends,
Any Idea !!
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
hii
you can change the background color of your expression
Check with this image