topic Re: Color Change to select Field in QlikView

Color Change to select Field

krishna20 — Sun, 29 Mar 2015 10:39:07 GMT

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

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

Re: Color Change to select Field

krishna20 — Sun, 29 Mar 2015 11:41:42 GMT

Hi Friends,

Any Idea !!

Re: Color Change to select Field

stigchel — Sun, 29 Mar 2015 12:17:34 GMT

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

Re: Color Change to select Field

Mon, 30 Mar 2015 05:54:54 GMT

hii

you can change the background color of your expression

Check with this image