I am using QGIS 3.22.16, I try to select similar 'null' value in 2 different field. I tried the solutions suggested from one this exchange. Selecting features with equal values in different fields in QGIS None of these solution worked.

enter image description here

  • 1
    Please be more precise when saying "none of these solution worked". What exactly have you tried? What did/didn't happen?
    – Erik
    Commented Mar 22, 2023 at 14:38
  • I used the operator "Like" and "=" between the 2 fields. As well as the operator "To_int".
    – GIS Noh
    Commented Mar 22, 2023 at 14:49
  • I even tried the Regexp match and trim functions in the expression box. No data have been selected in the table.
    – GIS Noh
    Commented Mar 22, 2023 at 14:54

1 Answer 1


You can use is null:

"Tree_Wor1" is null and "Tree Wor_1" is null
  • 1
    Perfect, it worked .
    – GIS Noh
    Commented Mar 22, 2023 at 15:33

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.