Forum Discussion
Dinvae
3 years agoRegular Visitor
Slicer value Display
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_v...
amitchandak
3 years agoSuper User
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