topic Re: Text format a expression in a chart in QlikView

Text format a expression in a chart

qliktoview123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello ,

I need to change the text format of a particular expression.

example:

I want my Total revenue to be bold and font size of 10.

I am sharing the screenshot in the attachment.

Please help me out.

Thanks

Re: Text format a expression in a chart

Wed, 06 Jul 2016 08:18:27 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." FYR: Changing Fontsize on the Data Point Values | Qlik CommunityBy Johan

Hope it helps you!!

Re: Text format a expression in a chart

qliktoview123 — Wed, 06 Jul 2016 09:14:55 GMT

how can I use them in a expression.Please tell me.

Re: Text format a expression in a chart

Wed, 06 Jul 2016 09:35:30 GMT

Hope it helps bro!

Re: Text format a expression in a chart

qliktoview123 — Wed, 06 Jul 2016 09:44:40 GMT

If i am choosing H1 or H6,the font size is same.It is not working.

Re: Text format a expression in a chart

qlikview979 — Wed, 06 Jul 2016 09:47:22 GMT

HI,

do you want like this

Re: Text format a expression in a chart

qliktoview123 — Wed, 06 Jul 2016 09:49:44 GMT

no,not this.

Re: Text format a expression in a chart

qliktoview123 — Wed, 06 Jul 2016 10:05:50 GMT

I just want to make my label bold,can it happen?

Re: Text format a expression in a chart

Anil_Babu_Samineni — Wed, 06 Jul 2016 10:19:38 GMT

Atul,

For bold you need to put '<b>'

for Size you need to add Headers.

Here, Final Expressions are

You can use the expression's Text Format to change the font size of the numbers displayed on the bar. Values <H1> through <H6> will change the size.

'<H1'> & '<b>'

'<H2'> & '<b>'

'<H3'> & '<b>'

'<H4'> & '<b>'

'<H5'> & '<b>'

'<H6'> & '<b>'

The H1=36px, H2=24px, H3=21px, H4=18px, H5=16px, H6=14px, that is. (or, if you like, H1=2em, H2=1.5em, H3=1.17em, etc., the point isn't the numbers themselves, but the relation between them)

Re: Text format a expression in a chart

geetha_n — Mon, 26 Nov 2018 11:22:49 GMT

Hi all,

I tried <b>, <i> these are working fine, but <h1> to <h6> are not working.

Any idea of solving these.

Re: Text format a expression in a chart

jakobjosef — Fri, 26 Feb 2021 11:40:42 GMT

did you find a solution? Struggling with the same problem...

Re: Text format a expression in a chart

Miko93 — Fri, 08 Oct 2021 13:46:02 GMT

thank you all,

I tried the same as explained above but its not working for me:
Sorting = 1 sould be formatted bold but its not.

can somebody help me?