How to hide labels in intersecting layers using label expressions in QGIS?

Question

We are using views to build dynamic tables of utilization and enrollment. When mapping, however, the schools that meet both thresholds both display, and I can't figure out how to remove the labels from one layer if the same feature is in the 2nd layer:

I have seen other posts that discuss using the get_feature() expression builder, but I can't see how to get that to work.

Here's an attempt trying to hide the labels from the enrollment layer if the schnum is present in the Current Utilization layer using a label expression:

case 
when schnum in (get_feature( 'Current Utilization', 'schnum', '*')) 
then ' ' 
else abbreviation 
end

But that doesn't seem to work, and I can't find much documentation to explain if this is even possible.

Answer 1

get_feature() returns the first record which matches with the third parameter. As you have been trying to give it wildcard, I am sure you are not interested in its attribute (second parameter) itself.

I would recommend to use refFunctions plugin:

CASE 
WHEN geomintersects('Current Utilization', $geometry)
THEN ''
ELSE abbreviation
END

Answer 2

I have not seen that before.

I am sure there is a reason you may not want to do this,

Add a (label) field to the enrollment layer.

Then join the two tables by school name or number.

Then add a "yes" or "no" or a space or any other text to the (label) field of the rows where there are two school names or numbers.

Then break the join.

Label the enrollment layer contingent upon the label field being populated.

This would be a quick and dirty solution, unless I am totally misunderstanding the question.