Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax for Background Color (ACL -> QV)

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.

2 Replies
hic
Former Employee
Former Employee

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
Master III
Master III

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