Filtering maximum and minimum length in QGIS Attribute table

Question

My Dataset contains the field "length" with numbers from 1 to 100. I just want to filter data which are greater than 50 or which are less than 50.

I just use the formula:

"Length" < 50 And "Length" > 100

But this filters data into series.

I don't understand what your target is. If you create a filter for data whose length attribute is greater than 50 or smaller than 50, you will get the whole data set. Also, in your example, you use "Length" > 100 which will yield no data since you don't have values over 100. I guess you should duplicate your layer and set a filter "Length" < 50 in one of them, and "Length" > 49 in the other one — jpinilla, May 20 at 18:00

Taras · Accepted Answer · 2023-05-20 08:49:08Z

5

The logical operator should be OR instead of AND.

"Length" < 50 OR "Length" > 100

See Logical connective for more details.

Another solution will employ NOT BETWEEN operator:

"Length" NOT BETWEEN 50 AND 100

answered May 20 at 8:44

Taras

29.9k4 gold badges54 silver badges126 bronze badges

Add a comment |

1 Answer 1