QGIS: Replace All NULL Values in A Column Using (Calculated) Values from Other Column(s)

#qgis #qgistutorials #gis #gis
If you like my video and think it is helpful, please consider buying me a coffee (paypal.me/Geon....

[@badalpokharel6270]

Thank you for such a good explanation.

[@DataVisFun]

You are always welcome :)

[@samarattaher4978]

Thank you for this video

[@DataVisFun]

You are welcome!

[@QeisAhmad]

hallo sir can i get the code block here, cause i can't see it clearly, thanks sir

[@DataVisFun]

Sure. Please note that in this video I am just giving a very simple example. I want EP95 to be equal to (DP+DM)/2 when EP95 is NULL. Or else EP95 keeps its original value. So the codes are:
CASE
WHEN "EP95" IS NULL THEN ("DP"+"DM")/2
ELSE "EP95"
END
Note that the column names are quoted.

[@abdullahmohammed4737]

This should not take a minute to explain. Thanks tho

[@DataVisFun]

Thank you for your thought :)