topic Re: Changing the text format of expression in QlikView

Changing the text format of expression

alec1982 — Wed, 13 Jun 2012 21:01:15 GMT

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,

Re: Changing the text format of expression

Sokkorn — Thu, 14 Jun 2012 00:48:19 GMT

Hi,

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

Regards,

Sokkorn

Re: Changing the text format of expression

alec1982 — Thu, 14 Jun 2012 02:14:58 GMT

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,

Re: Changing the text format of expression

Sokkorn — Thu, 14 Jun 2012 02:25:43 GMT

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

Re: Changing the text format of expression

alec1982 — Thu, 14 Jun 2012 02:30:42 GMT

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

Re: Changing the text format of expression

alec1982 — Thu, 14 Jun 2012 02:38:18 GMT

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

Re: Changing the text format of expression

Sokkorn — Thu, 14 Jun 2012 02:52:26 GMT

Hi,

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

Regards,

Sokkorn

Re: Changing the text format of expression

alec1982 — Thu, 14 Jun 2012 02:56:00 GMT

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,

Re: Changing the text format of expression

eromiyasimon — Tue, 22 Nov 2016 05:27:19 GMT

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

Re: Changing the text format of expression

Tue, 30 May 2017 13:20:12 GMT

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.