14 Replies Latest reply: Jul 10, 2017 8:57 PM by Paul Dan RSS

    Dynamically Changing the colour of the dimension axis label

      I have two tables that show some values, for example


      Table 1 - Stats           Table 2 - Current People

      Name       Qty                   Name      Current

      Mr Blog     50                   Mr Blog         1

      Mrs Blog   10                   Ms Blog         1            

      Ms Blog     25



      I want the Graph to show the label text colour to Green if they are current and orange if they are not, for example


      Qlikview Blog Chart.bmp

      I used the Axis Font Colour to have the following formula:


      IF(Sum (Current)>0, RGB(24,117,11),RGB(241,111,14))


      But this only does the colour for the whole graph, not for each individual bar.


      How do I make it work for each bar?