topic Re: Attendance Dashboard in QlikView

Attendance Dashboard

Sun, 31 Mar 2013 03:40:25 GMT

Hi,

Im new to qlikview dashboard. i would like to ask for help. i am tasked to create a dashboard on the biometrics attendance. Below is a sample of my raw data:

name access yy mm dd hour min rev1 rid depart ymd ymdhm inout

Rob Smith 000000451733 2013 02 20 14 26 0 009 P2P 20130220 201302201426 IN

Rob Smith 000000451733 2013 03 06 10 08 0 009 P2P 20130306 201303061008 IN

Rob Smith 000000451733 2013 03 06 15 16 0 009 P2P 20130306 201303061516 OUT

Edward John 000000451733 2013 03 06 15 42 0 009 P2P 20130306 201303061542 IN

I need to create a report of those who came in later than 8am for the morning in and who went out before 5pm for the out.

then would like also to see the average time in and out of each depart.

Re: Attendance Dashboard

Sun, 31 Mar 2013 03:57:25 GMT

Hi Prinse

Your Raw data is in which Format(xls or .txt)

Pls attach sample raw data.

I will forward u

Regards,

Ananth

Re: Attendance Dashboard

Sun, 31 Mar 2013 04:12:06 GMT

Hi,

Please see below excel file raw data

Re: Attendance Dashboard

kaushiknsolanki — Sun, 31 Mar 2013 18:28:17 GMT

Hi,

Have a look at the application attached. Hope this will solve your problem.

Regards,

Kaushik Solanki

Re: Attendance Dashboard

Thu, 04 Apr 2013 00:19:15 GMT

thank you so much its now okay

Re: Attendance Dashboard

kaushiknsolanki — Thu, 04 Apr 2013 05:25:38 GMT

Hi,

Kindly close the post if you got the solution.

Regards,

Kaushik Solanki