In QGIS 3.22 I would like to label an area with decimal values. In the attribute table, the values are displayed separated by commas, but the areas are labelled separated by periods.
After converting to string and replacing "." with ","
-
2What is the data type of the column?– BeraCommented Jan 23 at 18:28
-
data type is real– stefanCommented Jan 23 at 18:29
-
1Please, do not forget about "What should I do when someone answers my question?"– Taras ♦Commented Mar 4 at 19:49
Add a comment
|
1 Answer
If you have QGIS 3.28 or newer, you can use this expression to remove the thousand separator:**
format_number("Area", places:=1, omit_group_separators:=true)
You need to use the format_number function as your label expression:
format_number("Area", places:=1)
It will format your real value to a string using your locale formatting (comma vs period separator).
The locale can be changed (overridden) in Options > General > Override System Locale > Locale
you can also directly override the locale in the expression:
format_number("Area", places:=1, language:='fr')
-
this works. thx. but... a locale separator for thousands like "space" or "." is now generated in between, eg 1 250,2 or 1.250,2 is there a way to get it this way > 1250,2?– stefanCommented Jan 24 at 12:33
-
There seem to be issues with format_number() since I can't seem to be able to remove the space thousand separator for some reason. And it shouldn't show up at all since I have unchecked the "Show group (thousand) separator" in the "Override System Locale" settings– KalakCommented Jan 24 at 13:15
-
there seems to be no solution concerning this problem. i've tried to enable "Show group (thousand) separator" in the "Override System Locale" settings with no positive effect.– stefanCommented Jan 24 at 14:18
-
I have created an issue on the QGIS GitHub if you would like to see if anything changes or if we missed something github.com/qgis/QGIS/issues/55972– KalakCommented Jan 24 at 14:23
-