Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Agis-Kalogiannis
Employee
Employee

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

View solution in original post

4 Replies
Agis-Kalogiannis
Employee
Employee

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
Partner - Champion
Partner - Champion

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
Author

Thanks you I use your recommandation

Not applicable
Author

Thank you