topic Re: If statement to color cells red or green in QlikView

If statement to color cells red or green

Mon, 12 Jan 2015 18:22:04 GMT

Hello,

I have an expression in the custom format cell area of my table and I want it to color the cell red if the value is 'N' and green if the value is 'Y'.

(Complete = 'N', red(), if(Complete = 'Y', green())

I have this expression that works, except if one value is 'Y' it colors the entire column green instead of just the individual cell. Anyone have any idea why this is happening?

Re: If statement to color cells red or green

Clever_Anjos — Mon, 12 Jan 2015 18:23:47 GMT

What kind of table are you using?

Re: If statement to color cells red or green

Mon, 12 Jan 2015 18:25:19 GMT

a straight table

Re: If statement to color cells red or green

Clever_Anjos — Mon, 12 Jan 2015 18:42:48 GMT

Did you try using "Visual Cues" tab?

Re: If statement to color cells red or green

jpapador — Mon, 12 Jan 2015 18:45:23 GMT

Instead of using the custom format cell function go to the expressions tab and enter your expression in background color

Click the plus next to the expression you want to conditionally color and then click on background color and paste your expression into the definition box.

Re: If statement to color cells red or green

engishfaque — Mon, 12 Jan 2015 18:59:43 GMT

Dear Brandon,

Go to your your "Expression" > Background Color > Write your "expression" for color change as showed in the image > OK > Apply > OK.

Kind regards,

Ishfaque Ahmed

Re: If statement to color cells red or green

krishna20 — Tue, 13 Jan 2015 05:45:23 GMT

Hi,

If the above suggestions doesn't work for you.

Go to the expression tab and expand your expression by clicking at '+ '. Choose text format apply like this

if((Complete= 'N',Red(),Green())

Hope this helps

Regards

Krishna

Re: If statement to color cells red or green

tyagishaila — Tue, 13 Jan 2015 06:01:52 GMT

Try this expression,

if(Complete = 'N', red(), green())