Not working formula in Query Builder (Filter)

Question

I have been trying to filter a big dataset based on multiple values. The idea is to extend the formula as put in the image below. But even the first part doesn't work.
When I do: "kadastraleGemeenteWaarde" IN 'Ridderkerk' I get all results. If I do "kadastraleGemeenteWaarde" = 'Ridderkerk' I get no results.
A tip in the right direction would be appreciated a lot.

Erik · Answer

The following should work:
("kadastraleGemeenteWaarde" LIKE 'Ridderkerk') AND ("sectie" LIKE 'E')

The brackets are important for correct chaining of expressions. The change to LIKE is probably unnecessary, but to me it feels "cleaner", since I use IN only if I have a real list.

nr_aus · Answer

In QGIS, if you browse the data (Open Attribute Table) then you can hit the 'Filter' button at the top. This gives you a GUI filter window.
The best thing about this, is that it will give you the Expression at the bottom of that GUI.
In your instance, I used the GUI to enter Ridderkerk as a 'Contains' filter. then ran the filter. It returned the resultant features.
Better yet, it showed me the expression to use.
("kadastraleGemeenteWaarde" ILIKE '%Ridderkerk%')

This GUI should help you build your expression correctly.

Not working formula in Query Builder (Filter)

2 Answers

Add your own answers!

Ask a Question