Slicer value Display

[Dinvae]

Hi Experts,

Iam using below native sql in my desktop power file, this code is used at the slicer or global filter component

CASE WHEN to_varchar(to_varchar((v_FLAG = 'N')=false)='N') and to_varchar(to_varchar((v_FLAG = 'N')=null)='N') THEN 'N'
else to_varchar((REL_TYPE = 'GUARD')=true) END

My slicer values look like below:

Expected Result: above code both (null and false) should show 'N' and 'Y' instead (true) value

Appreciate any quick Help, Thank you

[amitchandak]

@Dinvae , It can be

case when COALESCE(v_FLAG, 'N') = 'N' then 'N' else 'Y' end

or

case when REL_TYPE = 'GUARD' then 'Y' else 'N'  end