topic Gauge Chart - Comma not decimal point for thousands in QlikView

Gauge Chart - Comma not decimal point for thousands

Tue, 03 Sep 2013 08:49:54 GMT

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

Re: Gauge Chart - Comma not decimal point for thousands

Gysbert_Wassenaar — Tue, 03 Sep 2013 09:16:56 GMT

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', '.', ',')

Re: Gauge Chart - Comma not decimal point for thousands

Tue, 03 Sep 2013 09:39:11 GMT

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

Re: Gauge Chart - Comma not decimal point for thousands

jonathandienst — Tue, 03 Sep 2013 09:52:27 GMT

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

Jonathan

Re: Gauge Chart - Comma not decimal point for thousands

Gysbert_Wassenaar — Tue, 03 Sep 2013 10:03:36 GMT

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

Re: Gauge Chart - Comma not decimal point for thousands

Tue, 03 Sep 2013 10:09:29 GMT

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

Re: Gauge Chart - Comma not decimal point for thousands

Fri, 04 Oct 2013 10:22:29 GMT

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