topic Re: Need Help : Timeline in QlikView

Need Help : Timeline

marwen_garwachi — Thu, 06 Feb 2014 12:29:40 GMT

Hello,

I want to produce a timeline showing me the tasks performed by each employee during a work day.

This will allow me to see the untapped time.

The end result should look like the graph below:

My data is as follows (see example attached):

Task_ID	Task_Desc	Task_Start_Time	Task_End_Time	Task_Duration	Employee_ID
100	T1	6/02/2014 11:34	6/02/2014 11:36	0:02:09	1011

I tried so many graphics without getting the result I want anyone have an idea? .

In advance thank you!

Re: Need Help : Timeline

Thu, 06 Feb 2014 15:25:39 GMT

Marwen,

If I were you I would try to use the funnel chart, and tweak it here and there.

I have assembled an example with your data. The issue I am facing is that you have got several task-desc for each hour, which is not the case in your image, you would need to tackle this.

Best,

Jerome Couzy

Re: Need Help : Timeline

marwen_garwachi — Thu, 06 Feb 2014 17:22:12 GMT

,Jérôme Couzy,

The employee can't do many tasks in the same time, The Data that i shared was just for exemple but in the reality this is not a big problem.

I'll Try this !

Thanks

Re: Need Help : Timeline

Thu, 06 Feb 2014 17:33:29 GMT

That's what I thought

In this case you're gonna be able to use the function Only() to evaluate the ID of the task or name or whatever to display it correctly. This function does only work when 1 single value is returned.

Keep me posted

Cheers,

Jerome Couzy

Re: Need Help : Timeline

Mon, 10 Feb 2014 12:57:52 GMT

Marwen,

Did you sort this out? Did it help?

Jerome