topic Formatting Text in QlikView

Formatting Text

Mon, 03 Feb 2014 14:04:11 GMT

Hello,

I want to format one of my rows in my straight table bold and another two Italic.

I have attached an example of my data, I am able to make most of the row bold however I have difficulty when it comes to the column that has expression Column(1)-Column(2).

I want the Total Revenue row to be bold and the 2 tier and Direct equipment rows to be italic.

Thanks in advance

Anna

Re: Formatting Text

Aurelien_Martinez — Mon, 03 Feb 2014 14:10:10 GMT

Hi,

You can use this on expression text format:

Pick(Match(Transtype, 'Total Revenue', '2Tier Equipment', 'Direct Equipment'), '<b>', '<i>', '<i>')

Best,

Aurélien

Re: Formatting Text

Mon, 03 Feb 2014 14:14:25 GMT

Thank You so so much.