Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Changing the text format of expression

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,

9 Replies
Sokkorn
Master
Master

Hi,

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

Regards,

Sokkorn

alec1982
Specialist II
Specialist II
Author

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
Master
Master

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
Specialist II
Specialist II
Author

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
Specialist II
Specialist II
Author

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
Master
Master

Hi,

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

Regards,

Sokkorn

alec1982
Specialist II
Specialist II
Author

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
Creator II
Creator II

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

Not applicable

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.