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.

  • 1
    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
    Commented May 20, 2023 at 18:00

1 Answer 1


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

Your Answer

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

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