Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Geeks,
I want to merge blank/empty values of a field RI to 'N' . I am using the below script to do that and it is not working. May I know what am i missing here ? Thank you in Advance
If(Isnull(RI), 'N', RI) as RI
Thank you,
CVR
A blank is not a null...
Try using Len(RI)=0 or, if there's a whitespace, Len(Trim(RI))=0
A blank is not a null...
Try using Len(RI)=0 or, if there's a whitespace, Len(Trim(RI))=0