Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
devarasu07
Master II
Master II

Conditional text vale background color for text object?

Hi,

I've below rule and tried to apply conditional value background color and it's not working. any suggestion. tks

if(Definition='Ideal',rgb(204, 255, 204),

if(Definition='Average',rgb(255, 173, 51),

if(Definition='Below Ave',rgb(255, 173, 51),RGB(250, 128, 114))))

Capture.JPG

1 Solution

Accepted Solutions
effinty2112
Master
Master

Hi Devarasu,

Maybe  a straight table like this:

1.jpg

Dimension:

=ValueList('Ideal','Average','Below Ave')

No expression, uncheck Suppress Zero Values and check Horizontal in Presentation tab.

Dimension label - Definition:

Dimension Background Color:

=Pick(Match(ValueList('Ideal','Average','Below Ave'),'Ideal','Average','Below Ave'),

RGB(204, 255, 204),

RGB(255, 173, 51),

RGB(250, 128, 114))

cheers

Andrew

View solution in original post

3 Replies
tresesco
MVP
MVP

One text box can't have multiple bkcolors. I guess, you are trying to represent this colors as legends, if so, you could simply use four text boxes with static color and text on it.

effinty2112
Master
Master

Hi Devarasu,

Maybe  a straight table like this:

1.jpg

Dimension:

=ValueList('Ideal','Average','Below Ave')

No expression, uncheck Suppress Zero Values and check Horizontal in Presentation tab.

Dimension label - Definition:

Dimension Background Color:

=Pick(Match(ValueList('Ideal','Average','Below Ave'),'Ideal','Average','Below Ave'),

RGB(204, 255, 204),

RGB(255, 173, 51),

RGB(250, 128, 114))

cheers

Andrew

effinty2112
Master
Master

Hi Devarasu,

Here's a correction to earlier post that ignored the Critical definition:

Dimension:

=ValueList('Ideal','Average','Below Ave','Critical')

Dimension Background Color:

=Pick(Match(ValueList('Ideal','Average','Below Ave','Critical'),'Ideal','Average','Below Ave','Critical'),

RGB(204, 255, 204),

RGB(255, 173, 51),

RGB(255, 173, 51),

RGB(250, 128, 114))

cheers

Andrew