Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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

Re: Gauge Chart - Comma not decimal point for thousands

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

6 Replies
MVP & Luminary
MVP & Luminary

Re: Gauge Chart - Comma not decimal point for thousands

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

Re: Gauge Chart - Comma not decimal point for thousands

Capture - Gauge chart.PNG.png

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

MVP
MVP

Re: Gauge Chart - Comma not decimal point for thousands

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
MVP & Luminary
MVP & Luminary

Re: Gauge Chart - Comma not decimal point for thousands

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


talk is cheap, supply exceeds demand
Not applicable

Re: Gauge Chart - Comma not decimal point for thousands

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

Not applicable

Re: Gauge Chart - Comma not decimal point for thousands

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