Anyway to color text inside textbox based on expression?

[mikael-c]

As asked here: https://community.qlik.com/t5/New-to-Qlik-Sense/Conditional-formatting-in-text-box-in-qliksense/td-p..., I'd like to color measures inside a text box based on an expression.

I did it with 4 KPIs, but ideally it would be inside the text box and I could place all the text to my liking. Further more, I have to mess with other textboxes for the titles and legend and everything. Plus with KPIs, you can't really control the text except for 3 sizes.

In the capture, I put the value for the first line ('Nord') where the color should change based on the value and the second line ('Est' ) to show how 'RGB(255,255,0)' is what I get when I insert the expression. 😞

Thanks.

[Taoufiq_Zarra]

@mikael-c 

maye be by using a mapping table, each region will be represented by a RGB color in the mapping and then use the value in the background color of the KPI

si j'ai bien compris le besoin