Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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())
Try this -
=if(Max(import_date)<today()-1,red())