Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate new field without blanks or NULLs

Hey community,

I want to create a new field with the expression if([Field1]+[Field 2]<'2014','YES','NO') as [New Field]

However, I want the expression to also ignore where there are nulls or 0s in either Field 1 or Field 2. How do I do this?

1 Reply
Not applicable
Author

just say alt(Field 1,0)+alt([Field 2],0)