attribute-tablelegendpoint-in-polygonqgis
I have multiple points with locations on a map and I want to calculate the exact number of points for a selected area.
I created a polygon and with Numbers of points on the polygon I created a new layer which in the attribute table contains the number of points in the polygon.
I want to export the map as an image. I used Print Layout but I don't know how to add the number of points from the attribute table to the legend.
I would expect the option "filter legend by map content" to cause the "filter count" to be limited to the features within the map extent. But you're right, the "feature count" is not filtered by the map extent.
This seems like a bug, so I made a bug report. Visit the bug report page to check on the status of having this bug fixed, but don't expect it to happen immediately. This is a pretty minor issue and the QGIS devs have a lot on their plates. In the meantime, try out the workaround below.
How to use expressions in a label item to display a count of features within the map extent:
This expression returns the map extent as a polygon: map_get(item_variables( 'Map1'),'map_extent'), where Map1 is the Id of the map. You have to define the Id of the map item in the Item properties panel.
Use the aggregate(count) function to count the points in a given category that intersect the map extent. The following example will count the points in the map canvas that have the value 'Group A' in their "category" field.
aggregate( 'New scratch layer','count',"category","category"='Group A' AND intersects($geometry,map_get(item_variables( 'Map1'),'map_extent')))
Repeat for each category.
Note: If you want a simple (uncategorized) count of all the features on your map, use this expression: aggregate('New scratch layer','count',"category",intersects($geometry,map_get(item_variables( 'Map1'),'map_extent')))
Two ways:
You can probably set up a graphical model to do all this if you are going to be doing this a number of times.
Best Answer
You can use the following expression if there is one polygon.