topic Re: Different font style in a column of a straight table in QlikView

Different font style in a column of a straight table

bhargav_bhat — Fri, 07 Apr 2017 12:04:57 GMT

Hi All,

we have a requirement where we need to add different font style in a single column of the straight table.

Does anybody have any idea about it

Regards,

Bhargav

Re: Different font style in a column of a straight table

Peter_Cammaert — Fri, 07 Apr 2017 12:34:30 GMT

There are limited formatting options by entering codes in the Text Format entry of the column expression tree. Go to Object Properties->Expressions, expand the expression tree, select the Text Format entry for the expression you want to change, and enter something like the following in the expression field on the right:

='<B>' // For bold text

='<I>' // For text in italics

='<U>' // For underlined text

or any combination of these three (grouped into the same string). All formatting specifications apply to the entire text representation of the expression output. In all cells, as well as in the totals line. You can make the formatting conditional by using IF() functions call.

Re: Different font style in a column of a straight table

Peter_Cammaert — Fri, 07 Apr 2017 12:38:30 GMT

BTW you can do the same for Dimensions by setting the Text Format entry in the Dimensions tree to one or more of the previous formatting codes.

Re: Different font style in a column of a straight table

bhargav_bhat — Fri, 07 Apr 2017 14:09:02 GMT

Hi Peter,

Thanks for replying

We need multiple font style in an expression in straight table For example.

Title: Qlikview (Fileld_name)

Here the Title is in Bold and Qlikview is regular .So can this be acheived in Qlikview

Regards,

Bhargav

Re: Different font style in a column of a straight table

Peter_Cammaert — Mon, 10 Apr 2017 07:47:34 GMT

No, that is not possible. As I said before:

"All formatting specifications apply to the entire text representation of the expression output. In all cells, as well as in the totals line."

You can make the formatting of a single expression field conditional, but not change just part of a resulting string representation.