topic Re: Attendance Dashboard for Employees in QlikView

Attendance Dashboard for Employees

Tue, 21 Apr 2015 02:39:48 GMT

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.

Re: Attendance Dashboard for Employees

Tue, 21 Apr 2015 08:46:20 GMT

can u please eloberate the scenario

Re: Attendance Dashboard for Employees

marcus_malinow — Tue, 21 Apr 2015 10:34:48 GMT

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

Re: Attendance Dashboard for Employees

Wed, 22 Apr 2015 03:11:17 GMT

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

Re: Attendance Dashboard for Employees

Wed, 22 Apr 2015 03:14:50 GMT

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

Re: Attendance Dashboard for Employees

marcus_malinow — Wed, 22 Apr 2015 08:14:55 GMT

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:

Re: Attendance Dashboard for Employees

Thu, 23 Apr 2015 00:49:25 GMT

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