How to handle the date null value in set analysis

[#1]

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

[sunny_talwar]

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)

[#3]

Hi,

Not getting the value.

Please find the below attached sample data

[sunny_talwar]

Take a look at the attached

[#5]

Hi,

I am using QlikSense..

can you please share the expression/script..

Sub2u444    

[sunny_talwar]

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)

[#7]

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