Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Making text bold

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

1 Solution

Accepted Solutions
awhitfield
Partner - Champion
Partner - Champion

Hi Andy,

easy peasy:

HTH

Andy

View solution in original post

7 Replies
kkkumar82
Specialist III
Specialist III

Hi,

DO you want to make it bold conditionally ?

Mark_Little
Luminary
Luminary

HI

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

Mark

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kkkumar82
Specialist III
Specialist III

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

asgardd2
Creator III
Creator III

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

awhitfield
Partner - Champion
Partner - Champion

Hi Andy,

easy peasy:

HTH

Andy

Not applicable
Author

Thank you to everyone for your quick replies.

Andy