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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmark1990
Contributor III
Contributor III

Change colors in QLikSense bar chart to custom colors (1 dimension, 2 measurements)

I tried to change the colors of a QLikSense bar-chart that has one dimension (WekenJaarWeek) and two measurements (=SaldoOHWNat, =SaldoOHWInt).

My current graph when using the automatic generated colors is:

2018-09-11_1452.png

I'd like to change the colors to the variables Kleur1 and Kleur2

Kleur1 = RGB(183, 190,  85)

Kleur2 = RGB(226, 230, 204)

I already changed to custom colors > On expression and used the following expression:

if(SaldoOHWNat, Kleur1,

if(SaldoOHWInt, Kleur2))

This results in the graph:

2018-09-11_1502.png

I need that the lower bars gets the color of the RGB value of Kleur2.

1 Reply
YoussefBelloum
Champion
Champion

Hi,

this code means what ?

if(SaldoOHWNat, Kleur1,

if(SaldoOHWInt, Kleur2))