Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Intime Outtime chart

Hi All,

How do i create a report of this type.

Here Intime and OutTime is the employee details.

Capture.JPG

Regards,

Keerthi KS

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

Yes like this by using some options. You need to use a bar chart. You need to turn on the Offset Bar option and specify an expression for that which is Time In. Then you have to calculate the interval by subtracting Time In from Time Out. Then lastly you have to add two Reference Lines to the chart on the Presentation Tab.... Have a look at the result:

2015-11-18 #1.PNG

View solution in original post

14 Replies
Not applicable
Author

hi Keerthi

can u share sample data

gautik92
Specialist III
Specialist III

is that in time and out time is login logout details?

Not applicable
Author

Yes Login and logout details

gautik92
Specialist III
Specialist III

you need to create bar chart with login and log out time?

petter
Partner - Champion III
Partner - Champion III

Yes like this by using some options. You need to use a bar chart. You need to turn on the Offset Bar option and specify an expression for that which is Time In. Then you have to calculate the interval by subtracting Time In from Time Out. Then lastly you have to add two Reference Lines to the chart on the Presentation Tab.... Have a look at the result:

2015-11-18 #1.PNG

Not applicable
Author

Hi Skjolden,

Thanks a lot. Can we display the intime and Outtime on the bars?

Regartds,

Keerthi KS

gautik92
Specialist III
Specialist III

create expressions with intime and out time and enable text as popup

Not applicable
Author

It has to be displayed on the bars. Not separate expressions.

How to calculate average time?

veidlburkhard
Creator III
Creator III

Hi Keerthi,

is it this what you want to show?

Gleitzeit.jpg