[Qgis-user] NULL in attribute table

[Patrick Dunford]

Use the coalesce function to convert the null to something like ''

e.g. coalesce ('Field', '')

then test in an expression.

Otherwise null propagation will cause the expression to fail.

On 7/07/22 04:15, Dario C via Qgis-user wrote:
> Hi there,
> I'm using an attribute table on my layout. For all the field without 
> any value I have NULL. Is there any way to add an expression like 
> (when FIELD is NULL Then ' ') ?
> Thank you
>
> regards,
> Dario
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user