Conditional Color Formating

[hkg_qlik]

Hi,

I want to color code the expression field (background color) based on the value range:

example:

if the cell value is >2 its green

if the cell value falls between = 2 and =1 its yellow

if the cell value falls between >1 and =-1 its red

Can someone help me with the syntax for the condition ?

Regards,

H

[sunny_talwar]

May be this:

If(Expression < 1, Red(), If(Expression < 2, Yellow(), Green())

[maxgro]

maybe (I used the sum(Amount), change according to your expression)

if(sum(Amount2)>2,                                              Green(),

if(sum(Amount2)=2 or sum(Amount2)=1,        Yellow(),

if(sum(Amount2)>-1 and sum(Amount2)<1,   Red(),

                                                                                  Black()

)))