topic Visual cues based on different field in QlikView

Visual cues based on different field

Thu, 21 May 2015 18:04:06 GMT

Hello

I have a table as follow

I would like to use Visual cues and change the color of labors as follow

if System_type is Type1 than if sum_of_labors is > 210 it's red if lower green
if System_type is Type2 than if sum_of_labors is > 95 it's red if lower green

thanks

Franck

Agis-Kalogiannis — Thu, 21 May 2015 19:52:29 GMT

What I would suggest, is, instead of using Visual Cues, to use the expression attributes.

In front of every expression on the expressions tab, there is a small plus sign.

If you click on it, you can see the expression attributes.

Select the Text Color for the Labors expression and type the following expression:

if(System_Type='Type1' AND sum_of_labors>210, lightred(), green())

Thanks

Agis

awhitfield — Fri, 22 May 2015 13:48:44 GMT

HI franck,

you would be best using back ground colour formatting against your expression, see example attached.

This has as back ground colour expression of:

if(System_Type='Type1' AND sum(Labors>210), lightred(),
if(System_Type='Type2' AND sum(Labors>95), lightred(), LightGreen()))

On the Sum(Labors) expression that gives the following results:

HTH Andy

Mon, 25 May 2015 10:38:44 GMT

Thanks you I use your recommandation

Mon, 25 May 2015 10:38:53 GMT

Thank you