Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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()))
@Nika3
Close the thread with the accepted solution
Thanks
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()))
@Nika3
Close the thread with the accepted solution
Thanks
@MatheusC Please consider writing a member article with your solution here:
https://community.qlik.com/t5/Member-Articles/tkb-p/qlik-communityarticles
kind regards...
I will do that, thanks
Att,
Matheus