topic Changing the font style in expression in QlikView

Changing the font style in expression

Fri, 29 Apr 2011 08:05:46 GMT

I have a text object in report and I want to make the font bold for some letters of my text. The text in text object is formed from the expression, it consists of some static strings and variables.

For example:

= 'Text1: ' & vMyText

here vMyText is a variable. I want to make the text 'Text1: ' bold. I tried using html tag like <b> but it did not work.

Please let me know how to achieve this.

Thanks,

Samir

Changing the font style in expression

Fri, 29 Apr 2011 08:55:33 GMT

Hi Samir,

I can change in my Report( I hope u mean Document Reports in Qlikview) and have the Option of Font.

If you mean Document Report, then Reports-> EditReports-> Item-> NewText and add your variable there

Hope it helps

Regards

Sravan

Changing the font style in expression

Fri, 29 Apr 2011 11:13:08 GMT

Hi Sravan,

I did not get what you said. Can you give me the expression which you used to make the font bold.

Thanks,

Samir

Changing the font style in expression

erichshiino — Fri, 29 Apr 2011 11:22:50 GMT

I don't think you can format part of your string within a single text box.

I'd say you need to include more than one text box (one for each segment with different format) to achieve this.

I hope someone can say something different.

Rgds,

Changing the font style in expression

christian77 — Fri, 29 Apr 2011 11:31:14 GMT

Hi:

Open your expression. Open Text Format and introduce the next expression: if(Field<2,'<b>','<i>'). Don't forget the quotes. It changes to Bold or Italic depending on the value of the field. If you export this graphic to a Report, it'll be actualized automatically. I hope it works for you.

Changing the font style in expression

Fri, 29 Apr 2011 14:48:32 GMT

HiErich,

The solution which you suggested (of different text objects), I had thought about it but it is the last option for me if there is no other way to do it. In my case the text object is large with lot of static and dynamic strings.

Thanks,

Samir

Changing the font style in expression

Fri, 29 Apr 2011 15:02:31 GMT

Hi,

Can you give a similar example with expression in text object ? Because there is no formatting option in text object expression as shown in your attached image.

Thanks,

Samir