Expression returning wrong value in QGIS Field Calculator?

Question

My QGIS Field Calculator expression:

case when "field_value" = '' or  "field_value" <> NULL then (if( "field_value" = '', 'N', 'Y')) end

returns null value even if "field_value" has something in it.

Note: "field_value" is in string.

ArMoraer · Accepted Answer · 2019-04-19 13:52:20Z

1

(Edited answer)

I think you can safely replace your main condition with "field_value" is not NULL (the comparison with null is somewhat counter-intuitive):

case
  when "field_value" is not null then if( "field_value" = '', 'N', 'Y')
end

answered Apr 19 at 13:28

ArMoraer

4,9012 gold badges16 silver badges40 bronze badges

I think else is an optional condition and not required. – Keshav Sharma Apr 19 at 13:39
this either isn't working. – Keshav Sharma Apr 19 at 13:43
@KeshavSharma You're right, I misunderstood your expression. I've edited my answer (and tested it this time...), I think it should work. – ArMoraer Apr 19 at 13:53

add a comment |

1 Answer 1