Change the label for a boolean: Instead of "True" and "False" I want the label to display "Occupied."
I have tried many iterations of this expression. Nothing has worked.
Case when "Field Name" = "TRUE" THEN "Occupied" Else Null End
You need to use single quotes, both for the value
'true' - should it be saved as a string in
"Field Name" (as explained by @Elio Diaz) - and for the word
'Occupied' otherwise the label would contain the value of the column
"Occupied", which is unlikely to exist.
Let's note that booleans can be represented in different ways. For instance if you are using Postgres the syntax would be
Case when "Field_Name" = 't' THEN 'Occupied' Else NULL End