1 Reply Latest reply: Sep 11, 2018 9:14 AM by youssef belloum RSS

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

    Mark Schuurman

      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.