I have a table of parcels. Each parcel can have multiple land use types (not necesarily distinct). Those are stored in another table - so in the UseType table, a parcel can show up as wineyard, agriculture, wineyard and orchard.

To get to know how many usetypes I have for each parcel, so my approach was:

count( "usetype",group_by:="parcel_ID")

Unfortunately, several features in the UseType table have NULL in the column "usetype" - how can i exclude them from the count?

1 Answer 1


This should do it:

count("usetype",group_by:="parcel_ID",filter:="usetype" is not NULL)

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.