15 Replies Latest reply: Jan 18, 2018 6:07 AM by Kizzy Davies RSS

    How can I make font or chart colour conditional in Qlik Sense?

    Kizzy Davies

      Hello,

       

      Is there any way to make the colour of the font in a text chart (or even better the background colour itself) change in accordance with the calculation?

       

      For example, if the expression delivers a minus amount I would like this to show in RED, if the expression delivers a plus amount I would like this in GREEN.

       

      I have found calculation for QLIK View but it does not work, it just replaces the calculation with words RED or GREEN.  Below if the calculation I tried on a text chart.


      if((Sum({$<[Requisition Status]={Closed}>}[Number of Filled Reqs])-1)>0,'Green','Red')


      Thanks,


      Kizzy