Color in straight table

[annanirvin]

Hi all.

I have a straight table as seen below. For every row, I would like the text to be green if the value in Ej påbörjade are greater than or equal to the target value in Kvota (i.e. 17 %, 39 % or 44 %) or red if the value is less than the target value. I've tried different solutions but always end up with the text in green since I seem to compare with the total kvota (100 %). Perhaps nested if's in the text color attribute would do it but I don't know how to get it right.

I would really appreciate som help here

Anna

[fvelascog72 · Accepted solution]

Hi,

I quick solution.

Hope it helps

Cheers.

[annanirvin]

Thanks, it all seems right to me but for some reason it don't work.

[BalaBhaskar_Qlik]

You can use if statements in your background color expression area to set different colors

based on the value within a cell for each of your dimensions and expressions.

Ex: if(Exp1>Expr2, Green(),Red())

[fvelascog72]

Can you share your app?

[annanirvin]

Sorry for my late reply. I have managed to solve the problem. It was the format that was wrong in my chart and when I corrected it worked well your proposal. Thank you!