Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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))