topic How to set text size in conditional formatting in QlikView

How to set text size in conditional formatting

Wed, 08 Jun 2011 11:07:00 GMT

In the properties of a chart, I have some expressions.

If I click on the plus sign of the expression I can set background color, text color, text format etc.

F.e. I have in text color the definition: If(1=1, Red() )

and in text format I have: If( 1=1, '<B><I>' ) making it bold italic.

Question: Which formula do I use to set the text size (making the font bigger)...

<H2> or something doesn't work. Or should I use a format expression around my value ? But how does that work...

How to set text size in conditional formatting

Wed, 08 Jun 2011 11:57:59 GMT

not sure there is a way with an html tag. other posts suggest that <H1> - <H6> work but I tested on qv9 and qv10 and there was no change to the font.

How to set text size in conditional formatting

Wed, 08 Jun 2011 12:02:26 GMT

No that doesn't work, I tried it.

Or should I use a format expression around my value ? But how does that work...

How to set text size in conditional formatting

Wed, 08 Jun 2011 12:13:27 GMT

see if this works...

high light your control

click View menu

click Design Grid (box appears around control)

Ctrl + Shift + Right-Click on the cell you want to edit

click Custom Format Cell

in the Text settings box change the Text size

Apply Changes to "current expression"

Apply

How to set text size in conditional formatting

Wed, 08 Jun 2011 12:43:03 GMT

well, it works for ALL the lines, not just one...

Re: How to set text size in conditional formatting

Sun, 16 Oct 2011 14:55:13 GMT

Hello,

Try to use single quates around the tag, ex. '<H5>'.

St0ny

Re: How to set text size in conditional formatting

Sokkorn — Mon, 17 Oct 2011 02:23:18 GMT

Hi,

Try to use this for text size (under Text Format): IF(1=1,'<H3>')

Regards,

Sokkorn

Re: How to set text size in conditional formatting

antonio_navas — Wed, 19 Sep 2012 14:52:06 GMT

Make as copys as you need of the calculate text, and make a conditional to view the result

(change the default colors as the result you want)

if(a>1)

Re: How to set text size in conditional formatting

antonio_navas — Wed, 19 Sep 2012 14:52:36 GMT

Make as copys as you need of the calculate text, and make a conditional to view the result

(change the default colors as the result you want)

if(a>1)

i try to learn better english

Re: How to set text size in conditional formatting

antonio_navas — Wed, 19 Sep 2012 14:52:50 GMT

Make as copys as you need of the calculate text, and make a conditional to view the result

(change the default colors as the result you want)

if(a>1)

i try to learn better english