Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to identify Null in Date field

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

3 Replies
Chanty4u
Esteemed Contributor III

Re: How to identify Null in Date field

try


Where LEN(TRIM([Date field])) < 1;

Re: How to identify Null in Date field

Not applicable

Re: How to identify Null in Date field

Hi,

Thanks for the reply.

Not getting the data.

Regards,

Sub2u444

Community Browser