topic Re: Mark values in Reporting Service & Alerting

Mark values

Nika3 — Fri, 15 Nov 2024 21:14:56 GMT

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!

Re: Mark values

MatheusC — Tue, 28 Nov 2023 14:56:33 GMT

@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()))

Re: Mark values

MatheusC — Fri, 01 Dec 2023 17:05:50 GMT

@Nika3
Close the thread with the accepted solution

Thanks

Re: Mark values

Frank_S — Fri, 01 Dec 2023 17:09:35 GMT

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

kind regards...

Re: Mark values

MatheusC — Fri, 01 Dec 2023 20:04:35 GMT

@Frank_S

I will do that, thanks

Att,

Matheus