topic Re: Color in straight table in QlikView

Color in straight table

annanirvin — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Color in straight table

fvelascog72 — Mon, 03 Jul 2017 11:56:45 GMT

Hi,

I quick solution.

Hope it helps

Cheers.

Re: Color in straight table

annanirvin — Mon, 03 Jul 2017 12:16:55 GMT

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

Re: Color in straight table

BalaBhaskar_Qlik — Mon, 03 Jul 2017 12:37:01 GMT

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

Re: Color in straight table

fvelascog72 — Tue, 04 Jul 2017 10:57:39 GMT

Can you share your app?

Re: Color in straight table

annanirvin — Sat, 08 Jul 2017 08:25:08 GMT

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!