topic Re: Format text of an expression in App Development

Format text of an expression

EvanBarrick — Thu, 24 Jan 2019 15:31:51 GMT

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

Re: Format text of an expression

sunny_talwar — Thu, 24 Jan 2019 15:34:53 GMT

Which object are you using this in?

Re: Format text of an expression

EvanBarrick — Thu, 24 Jan 2019 15:40:26 GMT

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))

Re: Format text of an expression

sunny_talwar — Thu, 24 Jan 2019 15:42:44 GMT

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

Re: Format text of an expression

dplr-rn — Thu, 24 Jan 2019 16:09:35 GMT

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

Re: Format text of an expression

EvanBarrick — Thu, 24 Jan 2019 16:39:08 GMT

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

Re: Format text of an expression

dplr-rn — Thu, 24 Jan 2019 16:53:32 GMT

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

Re: Format text of an expression

Fedemar — Fri, 25 Jan 2019 19:45:29 GMT

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!

Re: Format text of an expression

EvanBarrick — Mon, 28 Jan 2019 14:31:25 GMT

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