Hi, I'm trying to have a legend on my layout and I'd like to count the item shown in the legend which are inside the map extent.
I'm using this expression but: case 1) it gives me the total amount of the items (not filtered by map) case 2) it gives me the total amount of the items shown in the map, but not filtered by field case 1: aggregate( *'LAYERID*','count',"*KEY-FIELD*","*SPECIFIC-FIELD*" is not null, intersects($geometry,map_get(item_variables('Mappa1'),'map_extent'))) result: 1965 (the same of the total *"SPECIFIC-FIELD" is not null* in the project (not in the map) case 2 aggregate( '*LAYERID*','count',"*SPECIFIC-FIELD*" is not null, intersects($geometry,map_get(item_variables('Mappa1'),'map_extent'))) result: 583 (total amount of the items in the map, but not of that specific category) Difference between Case 1 and Case 2 is that case 2 has not "filtered by" values in the formula. Thank you for your support. Cheers
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user