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

qlikmark1990 — Tue, 11 Sep 2018 13:05:25 GMT

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:

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:

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

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

YoussefBelloum — Tue, 11 Sep 2018 13:14:40 GMT

Hi,

this code means what ?

if(SaldoOHWNat, Kleur1,

if(SaldoOHWInt, Kleur2))