topic Re: Making text bold in QlikView

Making text bold

Tue, 19 Jul 2016 08:31:29 GMT

I have the following expression to control the colour of a text field

=if ([# Late Quantity] > 0, RGB(255,0,0),RGB(0,0,0))

How can I make it bold as well.

Thanks

Andy

Re: Making text bold

kkkumar82 — Tue, 19 Jul 2016 08:33:52 GMT

Hi,

DO you want to make it bold conditionally ?

Re: Making text bold

Mark_Little — Tue, 19 Jul 2016 08:34:20 GMT

In Format text within the expression use ='<B>' or add it to an if statement.

Mark

Re: Making text bold

Anil_Babu_Samineni — Tue, 19 Jul 2016 08:35:13 GMT

Under Expression, You need to put the text format like --- '<b>'

Re: Making text bold

kkkumar82 — Tue, 19 Jul 2016 08:39:52 GMT

If you have this requirement for Text box then no way you have to use two text boxes one with bold in font tab, otherwise if it is in straight table or pivot or any chart as others said you need to go to

chart properties -> Expressions tab -> click the '+' symbol and go to text format and in the window type ='<B>'

Re: Making text bold

asgardd2 — Tue, 19 Jul 2016 09:20:44 GMT

You may use macros to change bold in text box, like this:

sub ChangeBold

set mybox = ActiveDocument.GetSheetObject("TX22")

mbp = mybox.GetProperties

mbp.Layout.Frame.Font.Bold = true 'or false, if you need no bold text.

mybox.SetProperties mbp

end sub

Re: Making text bold

awhitfield — Tue, 19 Jul 2016 09:41:57 GMT

Hi Andy,

easy peasy:

HTH

Andy

Re: Making text bold

Tue, 19 Jul 2016 10:28:00 GMT

Thank you to everyone for your quick replies.

Andy