Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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