Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Attendance Dashboard for Employees

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.

1 Solution

Accepted Solutions
marcus_malinow
Valued Contributor III

Re: Attendance Dashboard for Employees

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:

160908.PNG

View solution in original post

6 Replies
Not applicable

Re: Attendance Dashboard for Employees

can u please eloberate the scenario

marcus_malinow
Valued Contributor III

Re: Attendance Dashboard for Employees

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

Not applicable

Re: Attendance Dashboard for Employees

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

Not applicable

Re: Attendance Dashboard for Employees

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
Valued Contributor III

Re: Attendance Dashboard for Employees

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:

160908.PNG

View solution in original post

Not applicable

Re: Attendance Dashboard for Employees

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