topic Re: format text in variable in QlikView

format text in variable

curiousfellow — Wed, 11 Nov 2015 11:03:24 GMT

I have a text boxt that has an expression like this :

If(GetSelectedCount(field) = 0, $textstring, value)

$textstring is a variable with the string 'Please select field'

Now I want the text of the variable $textstring to be bold, but I can not find a way to do this.

Any help is appreciated

Re: format text in variable

sunny_talwar — Wed, 11 Nov 2015 11:07:36 GMT

I don't think that this functionality is available, but you might be able to use an extension -> Free Text Box Extension Object

Re: format text in variable

morganaaron — Wed, 11 Nov 2015 11:08:13 GMT

Properties > Font > Bold? Or do you not want the value to be bold? If so, create two text boxes using your if condition as a conditional show, have one be bold (textstring) and one not (value).

Re: format text in variable

jonathandienst — Wed, 11 Nov 2015 11:09:07 GMT

You cannot set a variable to 'bold', or any other style. A variable is a value, not a rendering. If you are displaying the value in a text box, you can set the text box font to bold. Other renderings will depend on how you are displaying the variable.

Re: format text in variable

marcus_sommer — Wed, 11 Nov 2015 11:59:14 GMT

An alternatively might be to use a straight-table instead of a textbox but are there more layout-requirements then BOLD then the suggestions from Sunny and Aaron are more suitable.

- Marcus

Re: format text in variable

curiousfellow — Wed, 11 Nov 2015 12:01:49 GMT

I want the value $textstring in the text box to be bold when getselectedcount(field) = 0 and the value of a calculated expression when getselectedcount(field) = 1

With an expression I can set the backgroundcolor and the fontcolor but apperantly not the fontstyle ?

Making two text boxes with a conditional show might be the good option.

Re: format text in variable

vsabbise — Wed, 12 Dec 2018 18:10:59 GMT

Could you tell me how to set the background color or font color using expressions. Thanks