Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Gauge Chart - Comma not decimal point for thousands

Morning all,

I've tried a few different ways to try and get the gauge chart to show the number in it's correct format, e.g. 1,284,613 rather than 1.284.613

Is this possible?

Thanks,

Simon

1 Solution

Accepted Solutions
Not applicable
Author

The best way is in fact to use a text object and have the freedom within there.

View solution in original post

6 Replies
Gysbert_Wassenaar

You can change the ThousandSep and DecimalSep variable in the script

SET ThousandSep=',';

SET DecimalSep='.';

Or you can set the Format Pattern for the expression on the Number tab. Or you can use the num function to specify a format pattern: num( myexpression, '#,##0', '.', ',')


talk is cheap, supply exceeds demand
Not applicable
Author

Capture - Gauge chart.PNG.png

Thank you, I've tried those. Is it just that this chart can't produce commas?

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Perhaps a number format has been set for this chart. Check Properties | Number and change the format if necessary.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Gysbert_Wassenaar

The LED display doesn't support comma's. It can only display dots.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks G, that's what I was starting to suspect!

Not applicable
Author

The best way is in fact to use a text object and have the freedom within there.