topic Re: Syntax for Background Color (ACL -> QV) in QlikView

Syntax for Background Color (ACL -> QV)

Wed, 04 Dec 2013 23:45:52 GMT

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.

Re: Syntax for Background Color (ACL -> QV)

hic — Thu, 05 Dec 2013 06:53:35 GMT

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

Re: Syntax for Background Color (ACL -> QV)

sujeetsingh — Thu, 05 Dec 2013 06:56:59 GMT

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