topic Re: Conditional text vale background color for text object? in QlikView

Conditional text vale background color for text object?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Conditional text vale background color for text object?

tresB — Thu, 24 Aug 2017 10:34:26 GMT

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.

Re: Conditional text vale background color for text object?

effinty2112 — Thu, 24 Aug 2017 10:53:52 GMT

Hi Devarasu,

Maybe a straight table like this:

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

Re: Conditional text vale background color for text object?

effinty2112 — Thu, 24 Aug 2017 10:57:44 GMT

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(250, 128, 114))

cheers

Andrew