Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

time sheet

i have to create time sheet table .

I have table with filed

Personal no (Text)

Personal Name (text)

EventTime (Timestamp)

what i already have

Personal NoPersonal nameEventTime
111Hana8.00 AM 12/7/2015
111Hana4.00 PM 12/7/2015
112Mohammed8.00 AM 12/7/2015
112Mohammed10.00 Am 12/7/2015
112Mohammed1.00 PM 12/7/2014
112Mohammed5.00 PM 12/7/2015

what i want to do , how can i make time in , time out

Personal NoPersonal nameTime InTime OutTotal Hours
111Hana8.00 AM4.0 PM8 hours
112Mohammed8.00 AM5.00 PM6 Hours ( He left from 10 to 1 , take first in and last out per day )

and the search will be in date from filed Timestamp

5 Replies
Gysbert_Wassenaar

See attached example. Note, if you have an odd number of records per user, i.e. the number of Time in events is different than the number of Time out events, then this can't work.


talk is cheap, supply exceeds demand
Not applicable
Author

Its not work , because its take min , max for all

find attachment Capture1.JPG

Capture2.JPG

Capture3.JPG

Gysbert_Wassenaar

Its not work , because its take min , max for all

What do you mean 'for all'? You get a min Time In and a max Time Out per user just like the example table you posted.


If you wanted a Date dimension you should have specified that.

You can create a Date dimension from the EventTime in the preceding load: floor(EventTime) as Date. You can then add that Date field as dimension in your chart.


talk is cheap, supply exceeds demand
qlikmsg4u
Specialist
Specialist

Hi Hana,

See the attchment

Not applicable
Author

Thank you Its work for me ,

i have other question ,

how can i got Avg in and Avg out ?

I try Avg(Min(Time(NewEventTime,'hh:mm')))

its not work .