How to identify Null in Date field

[#1]

Hi Folks,

I attached the my sample data in below.

In the attached sheet data i have date field, how to handle the null values in qliksense..

KPI'S:-

1. Ticket=High,CloseDate is not null -> Count

2. Ticket=Medium,CloseDate is not null -> Count

3. Ticket=Low,CloseDate is not null -> Count

Regards,

Sub2u444

[Chanty4u]

try

Where LEN(TRIM([Date field])) < 1;Returning Null values in date field

[sunny_talwar]

Check my response here: How to handle the date null value in set analysis

[#4]

Hi,

Thanks for the reply.

Not getting the data.

Regards,

Sub2u444