topic Re: Employee working hours chart in QlikView

Employee working hours chart

egoziyan — Wed, 23 Dec 2015 18:50:15 GMT

G'day

I need some help, I am trying to make a bar chart that will show to hours the employees worked on a given day.

I want the chart to emphasis if there are 2 employees at the same time.

my data contain the date, worker name, entry time, exit time

in my view I see a chart with axis between 8:00 to 23:00

the Y is worker name and the bar will be from entry till exit.

Any help / example on how to achieve it will be appreciated

Thanks

Yaniv

swuehl — Wed, 23 Dec 2015 19:44:41 GMT

There are different solutions to this kind of request, one could be using an approach like I've demonstrated here

egoziyan — Wed, 23 Dec 2015 20:32:25 GMT

Thanks swuehl

what I am trying to achieve is something like the picture.
it let me see clearly that between 12 until 13:30 there was 2 workers

lironbaram — Wed, 23 Dec 2015 20:37:10 GMT

have a look

at the attach example , may be it'll will help you

egoziyan — Wed, 23 Dec 2015 21:01:25 GMT

Thanks I am looking into it.

Do you know how do I make the chart to start always from 8 and to see the worker time on the actual time ?

petter — Wed, 23 Dec 2015 21:24:39 GMT

Can this be something that works for you:

egoziyan — Wed, 23 Dec 2015 21:52:37 GMT

Exactly what I was looking for

Thanks alot

petter — Wed, 23 Dec 2015 21:58:05 GMT

Thanks, I am happy to help