I have a problem, I'm trying to create a cartogram, I have data in an xlx file, after adding them to the layer I'm working on, I can't change their type. I'm trying to add a new field in the table and there I choose the float type but after trying to run I get an error. I don't know what I'm doing wrong. Some values from the table have as many as 15 decimal numbers, and in the xlx file I normally have them as 1 decimal number. I suspect this is a problem but I'm not sure. Anyone have any ideas how else can I change the "ogółem" field from text to float?
For the expression, try:
You often can't, and really never should, convert a field type in place. Create a new field of the data type you want, and then use the corresponding type cast to convert the data from string to a numeric value.