[Qgis-user] Fwd: error on counting inside a map

[Dario C]

Thank you DelazJ, it is working well!
there was a "," instead of AND condition!!!

Just a bit slow but it is working well!


I appreciate

Il giorno gio 3 giu 2021 alle ore 17:00 DelazJ <delazj at gmail.com> ha
scritto:

> Hi Dario,
> You want two filters: a field not being null and features being visible.
> But none of your expressions indicates that.
> Naming parameters could help you avoid falling in this trap (read the tip
> just above this section
> <https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/expression.html#some-use-cases-of-expressions>
> in the docs)
> try with
> aggregate( *'LAYERID*','count',"*KEY-FIELD*","*SPECIFIC-FIELD*" is not
> null *AND*
> intersects($geometry,map_get(item_variables('Mappa1'),'map_extent')))
>
> Hope that helps,
> Harrissou
>
> Le jeu. 3 juin 2021 à 11:38, Dario C <dario955i at gmail.com> a écrit :
>
>>
>> Sorry, I don't want to spam anybody. I send again my request, just in
>> case it never has never sent.
>> Thank you
>>
>>
>> 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 at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210604/f2234bdd/attachment.html>