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 have a table and would like to only show rows where there is no date (nulls).

I tried =ISNULL(Date) in the expression box but this does not exclude the rows with dates.

Currently looks like:

IDDATE
12018-01-01 10:00:00:000
2Null
3Null

What I would like:

IDDATE
2Null
3Null

Could someone please help me as to how I can achieve this?

Thank you in advance for any help.

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

try

May be a calculated Dimension:

If(Len(Trim([DATE])) = 0, 'Null', Null())

View solution in original post

3 Replies
Chanty4u
MVP
MVP

try

May be a calculated Dimension:

If(Len(Trim([DATE])) = 0, 'Null', Null())

Anonymous
Not applicable
Author

Hi Mateusz,

I am still getting rows with today's date.

Anonymous
Not applicable
Author

Hi Nagaian,

Still showing rows with today's date.