CASE
WHEN "%CC0002%" ="Seen" AND "%TT0002%" ='' THEN ''
WHEN "%CC0002%" ="Seen" AND "%TT0002%" ='SEEN' THEN 'POSITIVE'
WHEN "%CC0002%" ="Seen" AND "%TT0002%" ='Non seen' THEN 'Negative'
ELSE NULL
END
To embed this project on your website, copy the following code and paste it into your website's HTML: