Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rsingh43
Contributor

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
sureshqv
Esteemed Contributor III

Re: Isnull

try

May be a calculated Dimension:

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

3 Replies
sureshqv
Esteemed Contributor III

Re: Isnull

try

May be a calculated Dimension:

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

rsingh43
Contributor

Re: Isnull

Hi Mateusz,

I am still getting rows with today's date.

rsingh43
Contributor

Re: Isnull

Hi Nagaian,

Still showing rows with today's date.