topic If Statement - color question in App Development

If Statement - color question

jerryr125 — Wed, 22 Dec 2021 20:21:56 GMT

Hi -

I have the following if statement in a KPI:

If($(vAmount) < $(vBudget),'Under Budget',Over Budget')

Works fine.

Question : How to I make 'Under Budget' appear in a green font color and 'Over Budget' appear in red font color ?

Thoughts ?? Thanks - Jerry

Re: If Statement - color question

Anil_Babu_Samineni — Thu, 26 Dec 2019 12:26:22 GMT

Check if text color option for color? If so, you can define

If($(vAmount) < $(vBudget), Green(), Red())

Re: If Statement - color question

jerryr125 — Thu, 26 Dec 2019 12:35:04 GMT

Hi - I would like to text to still appear - I cannot change the conditional color.

thoughts ?

Re: If Statement - color question

Anil_Babu_Samineni — Thu, 26 Dec 2019 12:38:24 GMT

KPI will show in single row? May be i am not following, Can u please brief about?

Re: If Statement - color question

jerryr125 — Thu, 26 Dec 2019 15:26:40 GMT

The If statement is set up in the KPI to display either :

Over Budget

Under Budget

It displays text

If($(vAmount) < $(vBudget),'Under Budget',Over Budget')

How do I get the expression to display 'Under Budget' in green and 'Over Budget' in red ??

Thanks - Jerry

Re: If Statement - color question

jerryr125 — Fri, 27 Dec 2019 09:54:40 GMT

The If statement is set up in the KPI to display either :

Over Budget

Under Budget

It displays text

If($(vAmount) < $(vBudget),'Under Budget',Over Budget')

How do I get the expression to display 'Under Budget' in green and 'Over Budget' in red ??

Thanks - Jerry

Re: If Statement - color question

lorenzoconforti — Fri, 27 Dec 2019 10:11:40 GMT

In your KPI object, in the color section, toggle off "Library colors" and toggle on "Conditional colors"

Change the two colors in the bar that appears underneath according to the colors you need. As a limit value, insert your variable (i.e. = vBudget)

Lorenzo

Re: If Statement - color question

jerryr125 — Fri, 27 Dec 2019 13:04:04 GMT

Hi Lorenzo - here is the message that I am receiving:

Re: If Statement - color question

lorenzoconforti — Fri, 27 Dec 2019 13:11:34 GMT

use the Dual function in your if statement

If($(vAmount) < $(vBudget),dual('Under Budget',0) ,dual('Over Budget',1))

then in your color expression, set your limit to 0.5 and change the colors accordingly

Re: If Statement - color question

jerryr125 — Fri, 27 Dec 2019 13:26:41 GMT

thank you - that did the trick !!

I set the data element to display the "Measure Expression" and changed the colors accordingly - perfect! !