Attendance Dashboard for Employees

[#1]

Hi All,

          I was assigned a task to create a dashboard for checking the punctuality of employees. The reference point will be 8:00 am. I am new to Qlikview. I need to know if someone can help me with this. I have attached the excel sheet of raw data below.

[#2]

can u please eloberate the scenario

[marcus_malinow]

Hi Vekatesh,

see the attached.

I've created a field - OnTime - to indicate whether an employee is in attendance at or before 8 am.

I'm not too sure what [In Selected Date/Time] is - is this derived?, so have used [In Actual Date/Time].

Marcus

[#4]

Hi Praveen,

              Sure. The task assigned to me is to create a real time dashboard for recording the arrival time of the employees in the company. But the format in which the data is being extracted was a combination of date and time, so I had to manually change it to the required format. I am not sure how to put the exact value in a chart because Qliksense allows functions like Sum, Count, Avg, Max, Min only. SO i was looking for an option to enter the date and time as it is without any functions. Hope this helps.

Thanks in advance

[#5]

Hi Marcus,

              Thank you so much for your help, but unfortunately my company is not providing the fund the purchase the full version of Qlikview. I was not able to open the qlikview file which you have sent me. So sorry for the trouble caused. But for the purpose of learning a new software, I had downloaded a trial version of Qlikview and Qliksense, so that I can improve my software skills. Is there any possibility to send a snapshot of the output which you have obtained through your analysis. Thanks in advance

[marcus_malinow · Accepted solution]

Venkatesh,

my code is like so:

Attendance:
LOAD *,
if(InTime>(8/24), 'Late', 'On Time') as OnTime;
LOAD *,
time(subfield([In Actual Date/Time], ' ', 2)) as InTime,
date(daystart([In Actual Date/Time])) as InDate;
LOAD [Employee Name],
Timestamp(Timestamp#([In Actual Date/Time], 'dd/mm/yyyy hh:mm')) as [In Actual Date/Time]
FROM
[Attendance qlik.xls.xlsx]
(ooxml, embedded labels, table is [Raw Data])
WHERE NOT IsNull([Employee Name]);

And some of the results:

[#7]

Thank you so much Marcus. Now I got a clear idea on how to formulate it.