[GIS] QGIS CSV import of percentage values

csvqgis

I have a CSV file with four columns. The first column is text, and the succeeding columns are percentages. I have set up a csvt file with "String", "Integer", "Integer", "Integer"

When I import the file into QGIS as a delimited text layer, QGIS strips out all the percentages. They come in as null values.

LGA_NAME    Non-Indigenous  Aboriginal  Torres Strait Islander
Albury (C)  93% 2%  0%
Armidale Dumaresq (A)   88% 6%  0%
Ashfield (A)    93% 1%  0%
Auburn (C)  93% 1%  0%
Ballina (A) 93% 3%  0%
Balranald (A)   87% 6%  0%
Bankstown (C)   94% 1%  0%
Bathurst Regional (A)   91% 4%  0%
Bega Valley (A) 93% 3%  0%
Bellingen (A)   94% 3%  0%
Berrigan (A)    94% 2%  0%

The three headings are Non-Indigenous, Aboriginal, Torres Strait Islander.

Best Answer

Your numbers still contain the "%" symbol. If you want them to be recognized as numbers then loose the "%". i.e.:

LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander 
Albury (C);0.93;0.02;0.0
Armidale Dumaresq (A);0.88;0.06;0.00

Also be sure you are choosing the semicolon ";" as the "Custom delimiter" when you do the import.

Imported table

Related Question