Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
tahreen371
New 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
Valued Contributor III

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

try missingcount()

Channa