How to get count of Null and NotNull Values in Two KPI's In Qliksense

[tahreen371]

Hello All,

I have attached the Sample_Data and also the code developed.

Referring to the Sample Data the "Status" Column Highlighted in Yellow Needs to be created and i have created it as:

if(IsNull(Last_working_day),'Active','Inactive') as Status_Check,

Hence now i needed Count of Emp_code based selection of Month Field, If any month selected it should show two KPI's with Count of Active employees and Count of Inactive employees.

Blank Rows in Last_working_day indicates active employee and with last date indicates inactive employee.

I used the below code:
=Count({<Status_Check='Inactive'>}Emp_Code)

=Count({<Status_Check='Active'>}Emp_Code)

=Count({<Last_working_day={"Len(Trim(Last_working_day))=0"}>}Emp_Code)

But with any of the above Codes i dont get the count, it gives me zero.

Please please let me know if there is anything wrong the script or code.

[Channa]

try missingcount()