Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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)))