Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

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

6 Replies

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)

Not applicable

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

Not applicable

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)

Not applicable

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

Hi,

Thanks for reply,

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    

Community Browser