Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Visual cues based on different field

Hello

I have a table as follow

   

SNSystem_TypeLabors
SN1Type1200
SN2Type1150
SN3Type1250
SN4Type2100
SN5Type290

!

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

1 Solution

Accepted Solutions
Employee
Employee

Re: Visual cues based on different field

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

4 Replies
Employee
Employee

Re: Visual cues based on different field

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
Esteemed Contributor

Re: Visual cues based on different field

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

Not applicable

Re: Visual cues based on different field

Thanks you I use your recommandation

Not applicable

Re: Visual cues based on different field

Thank you

Community Browser