Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

try


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

sunny_talwar

Not applicable
Author

Hi,

Thanks for the reply.

Not getting the data.

Regards,

Sub2u444