Mark values

[Nika3]

Hello!
I have the following question: I have a number of ideas with different statuses. And for each status column "Days in state". But I need to restrict the days in state column, more precisely I need to mark the ideas that are longer than 40 days red, for example, then others yellow and the newest green. Or just mark them in red. How do you do that? Maybe with a formula for text color?
Thanks in advance!

[MatheusC · Accepted solution]

@Nika3 

Leaving an example of your data, what the field values ​​are like and even an example of what you want to achieve can be easier and faster to help you.
But basically, yes, you can put the color in the text color expression

Ex:
if(
Days
>40,red(),green())

or as you taught three colors assuming that there are other value ranges for each color, I leave an example, it looks like this:

if(
Days
>40,red(),
if(
Days
>=20
And 
Days
<40,yellow(),green()))

[MatheusC · Accepted solution]

@Nika3 
Close the thread with the accepted solution

Thanks

[Frank_S]

@MatheusC  Please consider writing a member article with your solution here:
https://community.qlik.com/t5/Member-Articles/tkb-p/qlik-communityarticles

kind regards...

[MatheusC]

@Frank_S 

I will do that, thanks

Att,

Matheus