Re: [Qgis-user] How to filter expression in aggregate

David Strip-4 wrote > aggregate( 'B','sum', "Confirmed", "Country_Region"  > ILIKE attribute($currentfeature, 'SOVEREIGNT')) Hi David, in the filter the source feature can be accessed with the variable @parent https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/functions_list.html#

Re: [Qgis-user] How to filter expression in aggregate

On 3/14/2021 5:28 PM, Andrea Giudiceandrea wrote: David Strip-4 wrote aggregate( 'B','sum', "Confirmed", "Country_Region"  ILIKE attribute($currentfeature, 'SOVEREIGNT')) Hi David, in the filter the source feature can be accessed with the variab

[Qgis-user] How to filter expression in aggregate

Let's say I have two layers with the following attributes: Layer A - SOVEREIGNT, Field2, Field3, ... Layer B - Country_Region, Confirmed, ... I want to aggregate the Confirmed field of Layer B into Layer A. I try to create a virtual field in Layer A with the _expres