topic Re: Text Formatting in QlikView

Text Formatting

samuel_brierley — Thu, 05 Sep 2013 09:28:47 GMT

Hi I Have the follwing expression in a text box, is there a way to format just the Calculation to be Bold

=' Total Assets Failed In Date Range Defined: '& count ([Fault Id])

Re: Text Formatting

Thu, 05 Sep 2013 09:32:00 GMT

Define 2 text boxes?

Re: Text Formatting

ngulliver — Thu, 05 Sep 2013 09:43:00 GMT

I don't think there is a way of changing the text format for part of a string of text within the same box. As Gerrit suggests, you might have to be creative in using two text boxes.

Re: Text Formatting

Thu, 05 Sep 2013 09:45:38 GMT

In my opinion you coulf create 2 text box with the same colour, therefore they will appear like one.

In the second one (with the calculation expression) you set the bold font.

Re: Text Formatting

samuel_brierley — Thu, 05 Sep 2013 10:59:41 GMT

I tried that but because my formula is dynamic it doesnt look too brilliant most of the time,

but thanks anyway

Re: Text Formatting

yevgeniy — Thu, 05 Sep 2013 11:01:51 GMT

In font - Color:

if(count ([Fault Id]) >=1000,Color(Blue()), Color(Yellow()))

but if need font style is bold:

Copy text box

add variable = if(count ([Fault Id]) >=1000,1, 2)

in first text box Layout-Show-Conditional: variable = 1 In Font-FontStyle-Bold

in 2 text box Layout-Show-Conditional: variable = 2 In Font-FontStyle-Normal