Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tracycrown
Contributor II

How to create conditional background color?

Dear all

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

Thank You

Tracy

Tags (1)
4 Replies
Highlighted
Partner
Partner

Re: How to create conditional background color?

Tracy, see the attaced

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

hope helps

Fernando

neetha_p
Honored Contributor

Re: How to create conditional background color?

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

or

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
Contributor

Re: How to create conditional background color?

Hi please find the  below one community.png

alibd225
Contributor

Re: How to create conditional background color?

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

ping.png