6 Replies Latest reply: Mar 24, 2016 8:55 AM by Subba Reddy

# How to handle the date null value in set analysis

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

• ###### Re: How to handle the date null value in set analysis

No data is attached, but may be this:

Count({<Ticket = {'High'}, CloseDate = {'*'}>}Ticket)

Count({<Ticket = {'Medium'}, CloseDate = {'*'}>}Ticket)

Count({<Ticket = {'Low'}, CloseDate = {'*'}>}Ticket)

or

Count({<Ticket = {'High'}, CloseDate = {"=Len(Trim(CloseDate)) > 0"}>}Ticket)

Count({<Ticket = {'Medium'}, CloseDate = {"=Len(Trim(CloseDate)) > 0"}>}Ticket)

Count({<Ticket = {'Low'}, CloseDate = {"=Len(Trim(CloseDate)) > 0"}>}Ticket)

• ###### Re: How to handle the date null value in set analysis

Hi,

Not getting the value.

Please find the below attached sample data

• ###### Re: How to handle the date null value in set analysis

Take a look at the attached

• ###### Re: How to handle the date null value in set analysis

Hi,

I am using QlikSense..

can you please share the expression/script..

Sub2u444

• ###### Re: How to handle the date null value in set analysis

Expression should still be the same my friend. I used these three expressions:

Count({<Ticket = {'High'}, CloseDate = {'*'}>}Ticket)

Count({<Ticket = {'Medium'}, CloseDate = {'*'}>}Ticket)

Count({<Ticket = {'Low'}, CloseDate = {'*'}>}Ticket)

• ###### Re: How to handle the date null value in set analysis

Hi,

i applied the above script what ever your shared, it was showing zero (0).

i applied like the below..

Count({<Ticket = {'Type 1 (Down)'}, CloseDate = {'Len(CloseDate)>0'}>}Ticket)  -- > 0

Regards,

Sub2u444