Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Formatting numbers in a chart legend

Hi,

I have a chart where I am trying to format the numbers in the legend.  I’d like the legend to displayed as ### but it is defaulting to #,###,###,### - see screenshot. 

Is it possible to format a number in a chart legend?  I'm not having any luck.

screenshot1.bmp

Tags (1)
5 Replies
Not applicable

Re: Formatting numbers in a chart legend

Since it's a matter of scale, can you take the field used for those numbers and divide by 10000000?

The other thing worth looking into is whether the data is of type Number and not a String.

Not applicable

Re: Formatting numbers in a chart legend

Hi,

This sort of works.  This formats both the legend and the actual number being displayed when you hover over the chart.  I am looking to only format the legend.  I need the actual number in its entirety displayed in the chart.

Not applicable

Re: Formatting numbers in a chart legend

Which version are you using, by the way?

In QV9, I see that the Legend is basically just a check box under "Dimensions".. not a lot of room for customization.

If it is the same in whichever version you are using, I suspect the way you format the dimension/axis, will also apply to the Legend. I imagine there is a rule somewhere about this being consistent as a best practice.

Not applicable

Re: Formatting numbers in a chart legend

QV10.  I'm not trying to format the dimension, I'm trying to format the expression.

brenner_martina
Valued Contributor II

Re: Formatting numbers in a chart legend

Hi,

you can use this expression as an additional expression and click the point Text as pop-up:

 

'Values = '&Num(Sum(Expression1),'###')

Greetings from Munich

Martina

Community Browser