Bar offset

[#1]

Hello all,

I need a little help with application that I'm making.

This is a job scheduling monitor, that uses logs for information.

In the chart below, name of the application is a dimension, and the expression is duration of execution of task.

I need to show whole 24 hours, like shown in the picture. Why is it showing only to 12am?

Also how should I offset the tasks to show when it started the execution and the duration?

Also I've attached the example of how I want to be executed.

App1 runs all day, every 10 minutes(couldnt draw all of them).

App2 starts at 04:00 and it is executed until 00:00.

App3 runs all day and i has long execution time.

How should I show that in chart?

[MK_QSL]

Little sample data would be good enough to work on your question...

[eduardo_sommer]

Is it possible to share your qvw?

Eduardo

[#4]

I've added the qvw.

[MK_QSL]

Try Bar OffSet as MIN(StartTimeStamp)

[#6]

Not working.

[eduardo_sommer]

To create a timeline in Qlikview, you need to use the duration of a task as the expression and the startin time as the offset. You are using the average of duration as the expression and duration as the offset. Besides this, your data covers more than one day.

If your tasks start everyday on the same time, and you want to draw the avg of duration, you can use this avg duration as the expression and the starting time as the offset.

Please, send more details of what you're trying to achieve.

Eduardo

[#8]

Hello Eduardo,

I want to show the task when it starts, its duration, and that to be shown in the chart like in the attachment.

I dont know if you understand me.