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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)