Changing the text format of expression

[alec1982]

Hi,

I am trying to change the size of the total showing on top of a chart but not sure how to do it.

Any Ideas?

Thxs,

[Sokkorn]

Hi,

Check this thread http://community.qlik.com/thread/52873

Regards,

Sokkorn

[alec1982]

This works perfect on a table chart but no a bar chart.

I am not sure if I should write a little code on the chart==> expression then expand the expression==> text format!

Any help will be appreciated.

Thxs,

[Sokkorn]

Hi,

Use expression in text format like this

IF(Dimensionality()=0,Arg)

**Arg can be

'<B>'          : Bold. Ex IF(Dimensionality()=0,'<B>' )

'<B><I>'     : Bold and Italic. Ex IF(Dimensionality()=0,'<B><I>' )

'<H6>'         : Font size. Ex IF(Dimensionality()=0,'<H6>' )

Hope this one may do your job.

Regards,

Sokkorn

[alec1982]

Hi thank you for the quick replay..

I got a little confused

I am new to QlikView

so on the text format definision I tried to add Font size. Ex IF(Dimensionality()=0,'<H6>' )but I am getting error.

I need to make the font Arial and the size 8 so what should I write?

Thxs

[alec1982]

I tried it and this would change the format of the values on the Y axel.

I am looking to change the format of the total that shows up on top of the chart

Thxs

[Sokkorn]

Hi,

Can you share your app? Then we look into it together.

Regards,

Sokkorn

[alec1982]

I found the place where to add the script but if you could help me with what the script should be, I would appreciate that. it is on the label of the chart.

the expression is Sum(x). and it is showing as label as well. I want to show it in Arial or Tahoma and the size 8.

Thxs,

[eromiyasimon]

hi,

i have increased the expression size as well as the legend size in your pie chart.

and i have attached the updated QVW along with this

refer the screen shots

to increase the Expression

TO increase the Legend Size

i hope this helps

[#10]

1-Expand your dimension

2-Clic to Text Format property and clic on Edit button

3-Type the next expression:

   if(Dimensionality() = 0, <B>)

This expression will change the text format to bold.

I hope it help you.