topic Conditional Color Formating in QlikView

Conditional Color Formating

hkg_qlik — Tue, 12 Jan 2016 20:22:37 GMT

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,

sunny_talwar — Tue, 12 Jan 2016 20:24:21 GMT

May be this:

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

maxgro — Tue, 12 Jan 2016 20:29:24 GMT

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

)))