Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tahreen371
Contributor III
Contributor III

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

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.

1 Reply
Channa
Specialist III
Specialist III

try missingcount()

Channa