topic Re: Intime Outtime chart in QlikView

Intime Outtime chart

Wed, 18 Nov 2015 09:37:05 GMT

Hi All,

How do i create a report of this type.

Here Intime and OutTime is the employee details.

Regards,

Keerthi KS

Re: Intime Outtime chart

Wed, 18 Nov 2015 09:50:37 GMT

hi Keerthi

can u share sample data

Re: Intime Outtime chart

gautik92 — Wed, 18 Nov 2015 09:54:23 GMT

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

Re: Intime Outtime chart

Wed, 18 Nov 2015 09:55:11 GMT

Yes Login and logout details

Re: Intime Outtime chart

gautik92 — Wed, 18 Nov 2015 09:59:25 GMT

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

Re: Intime Outtime chart

petter — Wed, 18 Nov 2015 10:05:40 GMT

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:

Re: Intime Outtime chart

Wed, 18 Nov 2015 10:31:42 GMT

Hi Skjolden,

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

Regartds,

Keerthi KS

Re: Intime Outtime chart

gautik92 — Wed, 18 Nov 2015 10:47:03 GMT

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

Re: Intime Outtime chart

Wed, 18 Nov 2015 10:56:29 GMT

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

How to calculate average time?

Re: Intime Outtime chart

veidlburkhard — Wed, 18 Nov 2015 15:20:47 GMT

Hi Keerthi,

is it this what you want to show?

Re: Intime Outtime chart

Thu, 19 Nov 2015 04:35:17 GMT

Yes Burkhard. How do i show values in that format ?

Re: Intime Outtime chart

veidlburkhard — Thu, 19 Nov 2015 08:49:35 GMT

Hi Keerthi,

in order to achieve this you have to switch from bar chart to combo chart.

In the chart properties expression tab under 'Display Options' mark 'Bar' and 'Values on Data Points' for the expression of the working time (on the presentation tab mark 'Set Values inside Segments').

Back on the expression tab add two new expressions:

i) in time,

the metric is "Sum(intime)" and you have to mark 'Line', 'Values on Data Points' and 'Invisible'. This will place the values of in time into the bottom of your bar segments.

ii) Out time,

the metric is "Dual(Time(Sum(Outtime), 'hh:mm'), Sum(Outtime) -'01:00' )" . Also you have to mark 'Line', 'Values on Data Points' and 'Invisible', but very important, because we are using the dual function you have to go to the number tab and mark 'Expression Default' for your expression 'Out time' otherwise the dual function will not work properly. The textual part of the dual function will give you the right value for your data point, whereas the numerical part will place this value just into the upper part of your bar segment.

That's all, very easy, no witchcraft.

Happy qliking

Burkhard

Re: Intime Outtime chart

Thu, 19 Nov 2015 10:00:42 GMT

where do i select invisible ?

Re: Intime Outtime chart

gautik92 — Thu, 19 Nov 2015 10:04:33 GMT

expressions tab

Re: Intime Outtime chart

Thu, 19 Nov 2015 10:06:45 GMT

Yea Got it