Format text of an expression

[EvanBarrick]

I have an expression, =(Sum({< PRICE ={">0.00"}>}QTY))-projectedSales.

I know how to apply RGB color based on an IF statement, however can I also make the font bold? If so, how

[sunny_talwar]

Which object are you using this in?

[EvanBarrick]

This is a table. Specifically, the measure of a chart. My current expression for the text is:

=IF(SUM(PRICE)-projREV >0, rgb(0,0,0), rgb(255,255,255))

[sunny_talwar]

Unfortunately, I am only seeing an option to add Background color expression and Text color expression for the measures. This was available in QlikView, but seems like it isn't available in Qlik Sense

[dplr-rn]

Have you added this

---

@EvanBarrick wrote:

This is a table. Specifically, the measure of a chart. My current expression for the text is:

=IF(SUM(PRICE)-projREV >0, rgb(0,0,0), rgb(255,255,255))

---

in Text Color expression section?

also isnt an aggregration function required for projREV 

[EvanBarrick]

I have, just wondering if there is a way to make the text bold?

[dplr-rn]

dont beleive it is possible directly. you may need to experiment with themes

[Fedemar]

could you try something like this?

=IF(SUM(PRICE)-projREV >0, '<b>'&SUM(PRICE)-projREV >0&'</b>', rgb(255,255,255))

Found someone that used in qlik this expression on a label:

'<b>'& [Field Name]& '</b>'

IDK if it works with the if clause.

Regards!

[EvanBarrick]

Thanks for the comment on this. Will try to make work, however an issue I am running into on this is that the data is in a KPI, so formatting the text is proving difficult