topic Re: Bold font in an expression? in App Development

Bold font in an expression?

Thu, 10 Sep 2015 16:11:52 GMT

In a standard table or a pivot table I'd like to highlight a row by making the font BOLD.

I'm not sure how to get this done. Any ideas?

For example, I have a table with the first column being called Product from the Product field in the data model.

If the Product value is "Furniture" I'd like that or the entire row to be in bold font....

sunny_talwar — Thu, 10 Sep 2015 18:17:17 GMT

You will need to do this for all your expression and dimension:

If(Product = 'Furniture', '<b>')

sunny_talwar — Thu, 10 Sep 2015 18:20:38 GMT

Attaching a sample qvw and screenshot of the output:

Anonymous — Thu, 10 Sep 2015 21:15:51 GMT

if u want to make the whole row or just the header bold then alternatively you can do this-

right click on header or any cell of the table > Click custom format cell > in the coming window you have option to control color and fonts.

Thu, 10 Sep 2015 21:27:16 GMT

This is a Qlik Sense question (I posted it on a Qlik Sense blog). Your answer is for QlikView, not Qlik Sense...

sunny_talwar — Fri, 11 Sep 2015 02:55:57 GMT

Sorry about that . Will look for a Qlik Sense solution now

sunny_talwar — Fri, 11 Sep 2015 03:29:42 GMT

I think Text Format option doesn't seem to be available in Qlik Sense so far, may be in the future versions we may get that functionality.

Best,

Sunny

Anonymous — Fri, 11 Sep 2015 08:38:24 GMT

Hello,

There is a background and text color option. You can highlight via using either of these options.

Serhan

vsabbise — Tue, 04 Dec 2018 15:56:07 GMT

Can I bold or apply color for a specific string in the text ?

I was able to convert it to upper case using the following. But would be nice to color the string or make it bold

(if(SubStringCount((wholetext),vWord1)>0,Replace(wholetext,vWord1,upper(vWord1))))

Any Help is highly appreciated. Thank You