10 Replies Latest reply: Feb 4, 2016 4:26 AM by Sangram Reddy RSS

    can a text box in Qlik Sense be given conditional font colour settings?

    Gus Feltham

      I have been using the fx feature of adding a measure to a text box which is great, but I also want to color code these outputs for red as negative, green as positive numbers.  Is this poss to control with the code?

      An example of one of my measures is below:

      (sum({<BudVsAct={"Budget"} ,ExpVsRev={"Expense"},  [Cost Centre]={23} >}[Period Balance])

      -sum({<BudVsAct={"Actual"} ,ExpVsRev={"Expense"},  [Cost Centre]={23} >}[Period Balance]))/1000

       

      And a get a text box with a combination of text and functions as per attached file, but I don't want to have to manually change the color to either red or green each month? 

       

      Thanks

      Gus