QGIS 2.18.5
I'm trying to add a condition to my expression in my html/css map tips where if a value is 'null', the result will show 'no data available'.
I've got a screenshot of my map tip so far for a feature with populated values (the date and the number of years). Not all the features have a date and integer associated with them.
What do I add to the code below?
<h1> [%"Local Auth"%] </h1>
<h3> Date LAP Adopted</h3> <p> [% "Local Pl_1" %] </p>
<h3> Five Year Housing Supply</h3> <p> [% "5 YHLS (#)" %] </p>
I tried
<h3> Date LAP Adopted</h3> <p> [%CASE WHEN "Local Pl_1" = ' ' THEN 'No Data Available' END%] </p>
but no luck.