Hi, I am using Text&image charts to show the KPIs as following(this graph is just a excel draft):
![Ivan_Yan_3-1587545819664.png Ivan_Yan_3-1587545819664.png](https://community.qlik.com/t5/image/serverpage/image-id/32266iDB48B7FD0985A7E4/image-size/medium?v=v2&px=400)
I want the yty ratio to be green in positive and red in negative. However, I cannot find a place to do the formula for Colour in Qlik. I can only find the place to set the static colour.
![Ivan_Yan_2-1587545511446.png Ivan_Yan_2-1587545511446.png](https://community.qlik.com/t5/image/serverpage/image-id/32265i0911239B6CCB4921/image-size/medium?v=v2&px=400)
Anyone knows how to deal with it? Or if there is other chart that can do the simliar result, which also works for me.