Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

devarasu07
Honored Contributor 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

Tags (2)
1 Solution

Accepted Solutions
effinty2112
Honored Contributor

Re: Conditional text vale background color for text object?

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

3 Replies
MVP
MVP

Re: Conditional text vale background color for text object?

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
Honored Contributor

Re: Conditional text vale background color for text object?

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

Highlighted
effinty2112
Honored Contributor

Re: Conditional text vale background color for text object?

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