Forum Discussion

Dinvae's avatar
Dinvae
Regular Visitor
3 years ago

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_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

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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