TransWikia.com

QGIS: Filtering aggregate returns different results with same value

Geographic Information Systems Asked by sdutcher on December 3, 2020

I have a joined layer that was created from a one-to-many join between a vector layer with three attributes (lat, long, siteid) and a data layer that contains many columns with many entries possessing identical ‘siteid’ fields. I need to find the minimum and maximum range of a field called ‘sampleno’ for each group of entries containing the same ‘siteid’.

Here’s what I tried:

maximum(sampleno,'', siteid=attribute($currentfeature,'siteid'))
|| 'n' ||
maximum(sampleno,'',siteid='1750')

I also tried:

 maximum(sampleno,'', siteid="siteid"))
 || 'n' ||
 maximum(sampleno,'',siteid='1750')

I don’t understand why entering a test value of ‘1750’ as the filter returns the result I expect but a value of "siteid" or attribute($currentfeature,’siteid’) doesn’t.

enter image description here

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP