topic How to create conditional background color? in QlikView

How to create conditional background color?

tracycrown — Sat, 22 Aug 2015 13:58:26 GMT

Dear all

Kindly advise how to create a conditional background colour for Category B & C ?.

Thank You

Tracy

fkeuroglian — Sat, 22 Aug 2015 14:12:33 GMT

Tracy, see the attaced

You have to put the condition in the "Background color" to each expression(in this case Category)

hope helps

Fernando

Anonymous — Sat, 22 Aug 2015 14:32:06 GMT

Hi Tracy,

Goto Expression

expand + sign for expression

and add below expression in background colour.

if(Category='A',yellow(),

if(Category='B',green(),

if(Category='C',red(),blue())))

if(Category='A', RGB(255,255,0),

if(Category='B',RGB(255,123,255),

if(Category='C',RGB(255,120,80),RGB(153,207,255))))

prabhas277 — Sun, 23 Aug 2015 06:24:01 GMT

Hi please find the below one

alibd225 — Sun, 23 Aug 2015 09:59:19 GMT

go chart properties . expand and set formula under background coolor

if(Category='A', RGB(255,255,0),

if(Category='B',RGB(255,123,255),

if(Category='C',RGB(255,120,80),RGB(153,207,255))))