topic Re: How to handle the date null value in set analysis in Connectivity & Data Prep

How to handle the date null value in set analysis

Thu, 24 Mar 2016 10:15:02 GMT

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

sunny_talwar — Thu, 24 Mar 2016 10:17:37 GMT

No data is attached, but may be this:

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

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

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

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

Thu, 24 Mar 2016 12:23:50 GMT

Hi,

Not getting the value.

Please find the below attached sample data

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

sunny_talwar — Thu, 24 Mar 2016 12:29:39 GMT

Take a look at the attached

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

Thu, 24 Mar 2016 12:38:31 GMT

Hi,

I am using QlikSense..

can you please share the expression/script..

Sub2u444

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

sunny_talwar — Thu, 24 Mar 2016 12:45:39 GMT

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

Thu, 24 Mar 2016 12:55:37 GMT

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