topic Re: Comma Style in chart title in QlikView

Comma Style in chart title

Anonymous — Wed, 06 May 2015 07:56:38 GMT

Good Day All,

I am trying to apply comma style in chart title, see the attachment but failed. However it worked in one chart !

, '#,##0') As far as I know, this is the comma style format, but is it applicable to all styles!! example:

Loss= 45411 after comma = 45,411

Profit= 1283987363 after comma = 1,283,987,363

,'#,##0.0%') As far as I know, this is the percentage format

Kindly explain both styles, how to apply comma's to any number in chart title. Thanks alot.

Alfie,

jonathandienst — Wed, 06 May 2015 08:16:02 GMT

You may need to supply the optional parameters too:

Num(....., '#,##0', '.', ',')

HTH

Jonathan

Anonymous — Wed, 06 May 2015 08:25:59 GMT

Thanks Jonathan,

Could you elaborate further. Where is the optional parameter located?
Note, I am using Chart title under General tab to display the figures. Thanks

Agis-Kalogiannis — Wed, 06 May 2015 15:39:04 GMT

In order to change the format of the number, you need to use the NUM() function.

An example would be:

num(count(Orders), '#,##0')

and this would give you a comma separated integer in the for or 1,253,423 as you mention above.

A different example:

num(sum(Sales), '#,##0.0%') will give you a percentage with one decimal point.

Wed, 06 May 2015 15:42:17 GMT

'$#,##0'

If you need to express in dollar format, i.e. - with a $ sign, you add $ sign in the beginning (just like above)