1

I have AOI layer named "Clusters" which is set as the Atlas coverage layer for my project

I want to sum the area(Hectares) of specific intersecting features from my "Senwes_All_Fields_Alb_AND_IntStreek" layer in a text box in the print composer.

The "Senwes_All_Fields_Alb_AND_IntStreek" layer contains: enter image description here

I would like to calculate the area of CATNAME_1 values intersecting the atlas feature using an expression

For example:

  • Horticulture = 500 Hectares
  • Non-pivot irrigated Annual Crop Cultivation / Planted Pastures = 2000 Hectares
  • Old Fields = 1000 Hectares
  • etc.

I have tried the aggregate function below, and got the TOTAL area of all CATNAME_1 values (Output preview: 347178.45651800046).

enter image description here

Now I would like to further break it down into the different values of CATNAME_1 as per example above.

How might I achieve that?

aggregate(
layer:= 'Senwes_All_Fields_Alb_AND_IntStreek',
aggregate:='sum',
expression:="AREA_HA",
filter:=intersects( $geometry,geometry(@atlas_feature) )
)

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.