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: 
Anonymous
Not applicable

ISNULL

Hi,

I am trying to write an expression using a date column but the ISNULL doesn't seem to be working. Can someone please tell me what I doing wrong with the below?

=IF(DATE ISNULL,'Piece In','Piece Out')

Thank you in advance.

1 Solution

Accepted Solutions
dapostolopoylos
Creator III
Creator III

You should  use:

=if(IsNull(Date),'Piece In','Piece Out')

Father/Husband/BI Developer

View solution in original post

3 Replies
dapostolopoylos
Creator III
Creator III

You should  use:

=if(IsNull(Date),'Piece In','Piece Out')

Father/Husband/BI Developer
sunny_talwar

May be try this

If(Len(Trim(DATE)) = 0, 'Piece In', 'Piece Out')

or

If(IsNull(DATE), 'Piece In', 'Piece Out')

Anonymous
Not applicable
Author

Thanks