I'm working with population data, and I have an issue when it comes to knowing the sum of a population inside the attribute table. I'd like to add all the numbers together from the column UN_2015_E. Is there a way to do so?
There are several methods that I may refer you to:
In the appearing window, you just need to choose the layer which you are interested in (population data) and choose the field that you want to explore, seems like
"UN_2015_E". The total number will be calculated just in the row called
The same result can be achieved with
View > Statistical summary
Or as it was already mentioned by @Erik you can proceed with
View > Panels > Statistics Panel
2. There is a plugin called Group Stats, see the image below.
3. If you open the Attribute table and put the layer in edited mode, then you will be able to type
sum("UN_2015_E") in the Expression dialogue and get the result as an Output preview.
In case if you are dealing not with integer values your expression can be altered as
4. With a hint from @J.R, there is also a possibility with a Virtual layer through
Layer > Add Layer > Add/Edit Virtual Layer.
In the Query panel, you just need to type a short statement, see the image below.
SELECT SUM(UN_2015_E) FROM Your_shapefile_name
In case of not integer values, you can adjust your query as following
SELECT ROUND(SUM(UN_2015_E)) FROM Your_shapefile_name
5. If you open
Plugins > Python Console you can achieve the result with typing following command in Python prompt
print(sum(filter(None,[f['UN_2015_E'] for f in qgis.utils.iface.activeLayer().getFeatures()])))
The code above calculates the sum of all
NOT NULL applying a filter.
6. And finally it is possible to obtain the summing values via QGIS domestic geoalgorithms. Search for
Basic statistics for numeric fields in
Processing Toolbox. Choose the field
"UN_2015_E" and get the result.
Add the statistics panel (
view - panels - statistics panel) to your window layout and then let it show you the statistics of your column.