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?