topic change the Text format to bold based on expression in QlikView

change the Text format to bold based on expression

Fri, 07 Jan 2011 10:08:42 GMT

Hi,

I have a requirement to change the text color and format based on a condition.

I have gone through the forum here and solved them except the text format.

This is the condition :

Percentage between 15-25% - yellow background & red plain font - I am able to do this now

Percentage greater than 25% - pink background & red bold font -- I am not able to get the font to bold

Please find the sample attached.

Again, there is an issue , as it is already stated as a bug , i am getting the default colour in the first line to the header. If there is any resolution let me know.

Thanks,

Srihari

SV:change the Text format to bold based on expression

gandalfgray — Fri, 07 Jan 2011 10:23:38 GMT

You can set those things in Chart Properties > Visual Cues:

SV:change the Text format to bold based on expression

Fri, 07 Jan 2011 10:38:45 GMT

Yes..that will work..

But is there any option we can set at the expression level.

I mean in the Expressions can we use TEXT FORMAT option to do this ?

Thanks,

Srihari

SV:change the Text format to bold based on expression

Fri, 07 Jan 2011 10:46:19 GMT

Hi Srihari

Change your text format expression to this:

IF([Percentage]>25,'')

The only thing that was missing is singlesitations around the tag.

SV:change the Text format to bold based on expression

Fri, 07 Jan 2011 10:52:29 GMT

That worked 🙂

Thanks

SV:change the Text format to bold based on expression

jonathandienst — Fri, 07 Jan 2011 10:52:42 GMT

Srihari

Yes you can.

Use an expression like for Text Format:

=If(Percentage > 0.25, '')

And for Background Color:

=If(Percentage > 0.25, RGB(255, 128, 128))

And for Color:

=If(Percentage > 0.25, RGB(255, 0, 0))

Adjust the expressions as necessary to fit your data. Adjust the colours as per your needs.

Jonathan

Edit - beaten to the punch!

SV:change the Text format to bold based on expression

gandalfgray — Fri, 07 Jan 2011 10:58:07 GMT

John and Jonathan are right.

QV Ref manual is wrong:

"The expression used as text format expression should return a string containing a B for bold text, I for italic text and/or U for underlined text."

ought to be corrected to:

"The expression used as text format expression should return a string containing a  for bold text,  for italic text and/or  for underlined text."