Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil-kumar5
Creator
Creator

Filled %

Hi Community,

Please find the below sample data. This is a daily work report (DWR) for employees from different departments. I have taken 11 days sample data from 01/21/2020 to 31/01/2020. This is really important to fill DWR on daily basis however few employee don't fill it timely and missed days. 

I just  wanted to get the percentage of deparments and employees filling DWR.. 

 

Please advise...

Employee_NameDateDepartmentRequired HoursHours Given
Henry01/21/2020HR88
Catherine01/23/2020R&D8.57
Karen01/24/2020Sales8.58
William01/23/2020R&D8.58
Mathew01/21/2020Sales8.57
Catherine01/25/2020R&D8.57
William01/26/2020R&D8.58
Mathew01/22/2020Sales8.58
Karen01/25/2020Sales8.59
William01/28/2020R&D8.57
Catherine01/27/2020R&D8.57
Henry01/27/2020HR88
William01/30/2020R&D8.59
Mathew01/23/2020Sales8.57
Henry01/25/2020HR87
Catherine01/28/2020R&D8.57
Mathew01/24/2020Sales8.58
Catherine01/29/2020R&D8.58
Henry01/31/2020HR88
Catherine01/30/2020R&D8.57
Mathew01/25/2020Sales8.57
Karen01/29/2020Sales8.59
Karen01/27/2020Sales8.57
Karen01/31/2020Sales8.59
Mathew01/26/2020Sales8.57
Mathew01/27/2020Sales8.59
Mathew01/28/2020Sales8.59
Mathew01/29/2020Sales8.59
Mathew01/30/2020Sales8.59
Mathew01/31/2020Sales8.59
5 Replies
Taoufiq_Zarra

@sunil-kumar5  can you share also the expected output or the formula you use ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
sunil-kumar5
Creator
Creator
Author

Hi Taoufiq,

Actually I am not sure as what to use in this case to get the output. But I can explain it further, so this is the daily data filled by the employees like 100 out 500 don't fill their DWR so we can have percentage or numbers as how many employees are not filling it department wise.

Regards,

Sunil

Kushal_Chawda

@sunil-kumar5  How do you know that who filled it correctly or not from above data?

sunil-kumar5
Creator
Creator
Author

Hi Kush, Sorry didn't get the notification for your reply.

The date column is freezed and auto selected, and there is no issue with the hours. 

The thing is that I need to provide the percentage of each department as how much they are compliant to filled it on daily basis.

 

Please advise

Almen
Creator
Creator

So the last column could contain empty values? In that case:

 

DWR:

Load

Count(Employee_Name),

Department

From YourDataSource Where(IsNum([Given Hours])=0) group by Department;