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

[varmekontrol]

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_number	import_date
6041654	2018.03.14
6041654	2018.03.13
6048888	2018.03.11
6048888	2018.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())

[Digvijay_Singh · Accepted solution]

Try this -

=if(Max(import_date)<today()-1,red())