Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tmap update output string if input string is null

Hey folks,

 

Please see pic attached. I am trying to catch if an input string is null if so I want to replace it with "Unknown" in the output row. I have tried several different ways but can't get it working any help is appreciated. 

 

Neil. 

 

0683p000009M1mi.jpg

Labels (2)
1 Solution

Accepted Solutions
vapukov
Master II
Master II

hi Neil,

 

as described it must be 

 

row5.Aligment==null?"Unknown":row5.Aligment

condition?true:false

 

in your case if null it continue to be null, and replace all not null

View solution in original post

2 Replies
vapukov
Master II
Master II

hi Neil,

 

as described it must be 

 

row5.Aligment==null?"Unknown":row5.Aligment

condition?true:false

 

in your case if null it continue to be null, and replace all not null

Anonymous
Not applicable
Author

Thanks very much worked perfectly!