topic Re: Condition Color in Simple KPI in Integration, Extension & APIs

Condition Color in Simple KPI

Adrielmf2 — Mon, 28 Mar 2022 20:35:29 GMT

Hallo,

Im trying to do a conditional color, and Im getting allways only one color. I put the same If as a dimension and i get the corret value, but the color doesnt work.

Re: Condition Color in Simple KPI

bgl-sjoyce — Mon, 28 Mar 2022 20:51:38 GMT

what is your if-statement. you aren't actually returning #green or #red right? it should be hex color code in single quotes or qlik function (green(), red()) not in single quotes.

I'm guessing your function is invalid and is just returning what you manually picked .

Re: Condition Color in Simple KPI

Adrielmf2 — Tue, 29 Mar 2022 10:57:59 GMT

Its not invalid. I just put the string in a Dimension to see if the logic works.

if(BusinessHrs<sum(ValorMeta),'#7CFC00','#FF0000')

The other one is the same, but with the string

if(BusinessHrs<sum(ValorMeta),'#green','#red')

Re: Condition Color in Simple KPI

stevejoyce — Tue, 29 Mar 2022 12:51:28 GMT

did you try

if(BusinessHrs<sum(ValorMeta),green(),red())

like i said, #green or #red is not going to actually change your color.

Your first expression assuming BusinessHrs<sum(ValorMeta) is correct.

Re: Condition Color in Simple KPI

Adrielmf2 — Tue, 29 Mar 2022 12:54:56 GMT

Yes, I tried if(BusinessHrs<sum(ValorMeta),green(),red()).

Like I said, i just put the string in the if to see if it was evaluating correctly, and it is. But in the color expression, doesnt work