topic Re: Changing Fontsize on the Data Point Values in QlikView

Changing Fontsize on the Data Point Values

martino — Wed, 30 Jun 2010 10:19:30 GMT

I Would like to change the fontsize on the "Values on Data Point" to a size 6 but can't seem to find a way.

I Only want to change the fontsize on the "Value On Data point" the rest of the chart should remain the default fontsize .

I expect that there is an expression that makes it possible but can't find it.

Thanks in advance.

Regards

Martin

Changing Fontsize on the Data Point Values

kji — Wed, 30 Jun 2010 11:09:56 GMT

"Value on Data" point uses the axis font by default, but can be modified using the "Text Format" sub expression, setting it to ='<H1>' will give you a larger font, H6 a smaller font, with a few options inbetween. You can also use <B>, <I> and <U> for Bold, italic and underline.

Changing Fontsize on the Data Point Values

martino — Wed, 30 Jun 2010 11:58:04 GMT

I already knew about the Bold, Italic and underlige BUT the '<H1>' was exactly what i needed.

Thank You A LOT.

/Martin

Changing Fontsize on the Data Point Values

mountaindude — Thu, 28 Apr 2011 16:22:58 GMT

Confirmed, this works at least for line charts.

For pie charts in a Trellis the Text Format sub expression doesn't seem to make any difference though.. Not sure if it is by design, or if it is possible, or if it's a bug..

Re: Changing Fontsize on the Data Point Values

Wed, 23 Apr 2014 05:54:59 GMT

I want BOLD and H1 at the same time. Could you share the syntax?

Re: Changing Fontsize on the Data Point Values

Tue, 07 Oct 2014 21:17:51 GMT

'<H1>' & '<B>'

Re: Changing Fontsize on the Data Point Values

Fri, 02 Jan 2015 07:31:25 GMT

Thanks dear

I already knew about the Bold, Italic and underline BUT the '<H1>' to '<H6>' was really helpful.

Thank You A LOT.

Jassi

Re: Changing Fontsize on the Data Point Values

Thu, 13 Apr 2017 11:14:32 GMT

Hi guys,

I have already used this solution and it works fine.

This time, I am trying to apply it to a pie chart to get external labels for each section.

I used the expression: if(count(distinct [Dimension])=1,[Dimension]) but I need to resize the font. It seems that the usual ='<H6>' solution does not work this time.

Any idea?

Thanks

Re: Changing Fontsize on the Data Point Values

Akshaya45 — Mon, 22 Apr 2019 15:25:50 GMT

Hi, Where do i use this expression , can you please give some sample QVF Files.

Please help !!!

Re: Changing Fontsize on the Data Point Values

kumarravi — Mon, 11 Apr 2022 17:33:00 GMT

Hi,

Right click and select properties
Go to expression
Click + on the left side of the expression
Click on Text font
- You can write following expression there:
- '<H1>' & '<B>' // H1 is the biggest and H6 is the smallest
- '<H2>' & '<B>'
- '<H3>' & '<B>'
- '<H4>' & '<B>'
- '<H5>' & '<B>'
- '<H6>' & '<B>'
- <U> //Underline
- <I> // Italic
- <B> // Bold

You can use combination of it using & operator.