Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
CVR
Creator
Creator

Merge of Blank/Empty values

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

 

 

CVR_1-1656341761035.png

Thank you,

CVR

 

Labels (1)
1 Solution

Accepted Solutions
Or
Champion
Champion

A blank is not a null...

Try using Len(RI)=0 or, if there's a whitespace, Len(Trim(RI))=0

View solution in original post

1 Reply
Or
Champion
Champion

A blank is not a null...

Try using Len(RI)=0 or, if there's a whitespace, Len(Trim(RI))=0