Syntax for Background Color (ACL -> QV)

[#1]

I am trying to figure out how to designate a color of a chart based on value of a field. New to QlikView and know what I am trying to say in ACL code. I want to use the RGB function in QV to decide the color... so something like this....

RGB(163,32,32)       IF UPPER(ALL(QlikViewField1)) = 'COLOR1'

RGB(123.42,255)     IF UPPER(ALL(QliKViewField2)) = 'COLOR2'

RGB(0,58,212)        IF UPPER(ALL(QlikViewField3)) = 'COLOR3'

RGB(255,255,255)

I am guessing I would put the code in the expression builder -> background color. Any ideas of how to do this? Thanks for the help.

[hic]

You almost have it. You should use the expression builder in the Expression Background Color. There you should write

= If( <Condition>, RGB(163,32,32),

     If( <Condition>, RGB(123.42,255),

     If( <Condition>, RGB(0,58,212), RGB(255,255,255))))

But it is unclear to me what you want to use as condition.

HIC

[sujeetsingh]

Just put this expression in background expression

= IF UPPER(ALL(QlikViewField1)) = 'COLOR1',RGB(163,32,32),

    IF UPPER(ALL(QliKViewField2)) = 'COLOR2',RGB(123,42,255),

     IF UPPER(ALL(QlikViewField3)) = 'COLOR3',RGB(0,58,212),RGB(255,255,255)))