Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
The best way is in fact to use a text object and have the freedom within there.
You can change the ThousandSep and DecimalSep variable in the script
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', '.', ',')
Thank you, I've tried those. Is it just that this chart can't produce commas?
Perhaps a number format has been set for this chart. Check Properties | Number and change the format if necessary.
The LED display doesn't support comma's. It can only display dots.
Thanks G, that's what I was starting to suspect!