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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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!