topic How to change a cells color based on a condition. in App Development

How to change a cells color based on a condition.

erickd1190 — Wed, 14 Dec 2016 23:30:27 GMT

Hi All,

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.

Example:

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.

Expression:

IF(([annual.autoCalendar.Date]+365)-TODAY()<90,

RGB(241,244,66),

IF(([annual.autoCalendar.Date]+365)-TODAY()<60,

RGB(244,170,66),

IF(([annual.autoCalendar.Date]+365)-TODAY()<30,

RGB(244,66,66),

RGB(66,244,69)

)

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.

Re: How to change a cells color based on a condition.

sunny_talwar — Wed, 14 Dec 2016 23:44:27 GMT

Shouldn't this be in the opposite order?

IF(([annual.autoCalendar.Date]+365)-TODAY()<30,

RGB(244,66,66),

IF(([annual.autoCalendar.Date]+365)-TODAY()<60,

RGB(244,170,66),

IF(([annual.autoCalendar.Date]+365)-TODAY()<90,

RGB(241,244,66),

RGB(66,244,69)

)

Re: How to change a cells color based on a condition.

erickd1190 — Wed, 14 Dec 2016 23:53:50 GMT

You are very right. Sunny thank you! The rush of the holidays must have fried my brain to forget such a small detail!