Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Master
Master

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

View solution in original post

3 Replies
Highlighted
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.

Highlighted
Master
Master

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

View solution in original post

Highlighted
Master
Master

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