Set Analysis with missing dates

[PamelaAlcantara]

Hi All,

I am trying to get the count of the items where the open date is not missing and the Close date is missing.

Item	Open Date	Close date
1	6/5/2020
2	6/4/2020
3	6/3/2020	6/4/2020
4	6/2/2020	6/3/2020
5	6/1/2020	6/2/2020
6	5/31/2020
7
8	6/5/2020
9	6/4/2020
10
11	6/5/2020	6/6/2020
12	6/4/2020	6/5/2020

I have tried the following

Count({<FIRST_OPEN_HSC_DATE={"*"},FIRST_CLOSE_HSC_DATE-={"*"}>}FIRST_CLOSE_HSC_DATE) 

and also

Count({<FIRST_OPEN_HSC_DATE={"*"},FIRST_CLOSE_HSC_DATE=e({<FIRST_CLOSE_HSC_DATE= {'*'}>})>}FIRST_OPEN_HSC_DATE) 

I don't have a problem with this first part (Open Date), but I can not get the right count of items where the close date is missing.

How can I count missing values on a set analysis?

Thank you so much

Pamela

[Taoufiq_Zarra]

@PamelaAlcantara 

May be :

=count({<[Open Date]={"=len([Open Date]) > 0"},[Close date]={"=len([Close date]) = 0"}>} Item)

output:

[PamelaAlcantara]

Thank you @Taoufiq_Zarra 

Unfortunately, I still can not get right count every time I tried to apply the formula 

[Close date]={"=len([Close date]) = 0"}

I get no values, if I change the formula to 

[Close date]={"len([close date])>0") I get the right classification and count, but with =0 I get nothing.

[Taoufiq_Zarra]

@PamelaAlcantara 

can you share  what's not working?

Attached the qliksense file

[PamelaAlcantara · Accepted solution]

I was finally able to solve it, the trick was to add 1-& before the second expression

Count({<Open Date={"=len([Open Date])>0"}>}{1-$<Close Date={"=len([Close Date])>0"}>}[Item]),

Thank you so much!