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



      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')