1 Reply Latest reply: Mar 14, 2018 10:45 AM by Digvijay Singh RSS

    Color background in table IF (FIELD) is less than x days, from today()

    Daniel Sørensen

      This is probably pretty simple, but I have looked in every corner of the community and haven't found an answer.

      I would like to color the background of a table IF my info is older than 1 day, 2 days - whatever.


      Dataload

      Serial_numberimport_date
      60416542018.03.14
      60416542018.03.13

      6048888

      2018.03.11
      60488882018.03.10


      Table in Qlik sense

      Serial_number
      6041654
      6048888

       

      QUESTION.

      How do I color the RED serial_number, if the import_date is older than 1 day? (like in the above tables)

       

      I have tried adding the background expression to the serial_number column.

      if(import_date < Today()-1, red())