This content has been marked as final. Show 2 replies
I am working on Qlik Sense and have a table built listing clients and contract dates. Once a year these contracts need to be updated and that can take time.
What I want to do is change the color of the cell if it is within 90,60, and 30 days of expiring.
Annual Date = 01/01/2016
Annual Due = 01/01/2017
Date: 10/01/2016 = Cell turns Yellow
11/01/2016 = Cell turns Orange
12/01/2016 = Cell turns Red
This way when can open this report and always see who is approaching renewal.
I am working withing the Chart Background Color expression to do this and currently have only been successful with yellow and green.
Is there a better way to do this? I kind of need to be able to do this within the Chart and not the Data Load Editor.
Thanks in advance.