Case When for YesNo in Custom Dimension

Looker Q&A Looker
, , ,
1

Hi,

I need to use YesNo Dimension in Case When statement and check if it’s not equals to “Yes”, then put some value.
It looks like this:

when(${my_table.my_yesno_column} != “Yes”, “Some Value”

But recieving error:

What is wrong here ?

2

Solved.

No quotes is needed for YesNo.

when(${my_table.my_yesno_column} != yes, “Some Value”