Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
abeeralharbi
New Contributor

employee absentees

this dataset represent a daily fingerprint for X company employees, each row is represent a scan of finger while the ID is represent the employee itself. 

How Can I calculate the absences based on the attached data?

2 Replies
Highlighted
Diter
New Contributor III

Re: employee absentees

Hi 

I think you need to have present the actives number as a reference to be compare vs. the attendance.

I can se in your data that the actives number is 286 with that information you can calculate de absences with some formula like this:

286-(Count (distinct ID))

I hava attached a picture for a better reference

hope this can help you.

 

regards,

 

Highlighted
Diter
New Contributor III

Re: employee absentees