Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

5 Replies
Highlighted
Not applicable

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

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.

Highlighted
Not applicable

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.

Highlighted
Not applicable

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

Highlighted
Partner
Partner

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