Case when similar in quicksight

Question & Answer
1

I have values null, 0, 1.
I want to create a calculated field that will give me ‘A’ for null and 0 and ‘I’ for 1.

similar to case when as below
case when status is null or 0 then ‘A’
when status = 1 then ‘I’ end

2

I recommend trying calculated field as ifelse(status = 1, 1,‘A’)

1 Like
3

@Raji_Sivasubramaniam What to do for null value?

4

You can check for nulls in the same way:
ifelse
( isNull({yourColumn}) or {yourcolumn) = 0, ‘A’, 1)