topic Re: Conditional formatting font in QlikView

Conditional formatting font

Tue, 07 Oct 2014 09:34:35 GMT

Hi All,

I'm using a text box in which I implemented a conditional formatting for the text color.I want to add conditional formatting to the style as well- add underline to the text.

Appreciate your help!

Thx,

Hila.

Re: Conditional formatting font

Gysbert_Wassenaar — Tue, 07 Oct 2014 09:42:13 GMT

That can't be done with a text box. Only the colors can be calculated conditionally. Well, maybe you could do something with a macro, but you're on your own there.

Re: Conditional formatting font

Tue, 07 Oct 2014 10:10:03 GMT

Dear Hila,

Go to the Visual Cues in Chart properties,

Select the Expression or the Field,

Then define the condition,

then select the text color ,Style and under line.

then press apply and OK.

Ragrds,

Priyantha.

Re: Conditional formatting font

Tue, 07 Oct 2014 10:27:45 GMT

Hi Priyantha,

I'm using a text box and not a chart...

But thanks for the effort

-Hila.

Re: Re: Conditional formatting font

flipside — Tue, 07 Oct 2014 10:44:25 GMT

Is it all the text you want to format, or just part of it, because Priyantha was onto something.

Please see attached.

flipside

EDIT: PS Ignore the bold and underline setting under Visual Cues, the magic is done in Expressions > Text Color & Text Format, but it is a chart.

Re: Re: Conditional formatting font

Tue, 07 Oct 2014 13:46:38 GMT

Nice one flipside! Very original thinking