Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Attendance Dashboard

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.

5 Replies
Not applicable
Author

Hi Prinse

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

Pls attach sample raw data.

I will forward u

Regards,

Ananth

Not applicable
Author

Hi,

Please see below excel file raw data

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

thank you so much its now okay

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Kindly close the post if you got the solution.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!