topic How to identify Null in Date field in App Development

How to identify Null in Date field

Thu, 24 Mar 2016 10:13:52 GMT

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 — Thu, 24 Mar 2016 10:17:17 GMT

try

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

sunny_talwar — Thu, 24 Mar 2016 10:24:16 GMT

Thu, 24 Mar 2016 12:24:50 GMT

Hi,

Thanks for the reply.

Not getting the data.

Regards,

Sub2u444