Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Bar offset

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?

Tags (1)
7 Replies
MVP
MVP

Re: Bar offset

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

eduardo_sommer
Valued Contributor

Re: Bar offset

Is it possible to share your qvw?

Eduardo

Not applicable

Re: Bar offset

I've added the qvw.

MVP
MVP

Re: Bar offset

Try Bar OffSet as MIN(StartTimeStamp)

Not applicable

Re: Bar offset

Not working.

eduardo_sommer
Valued Contributor

Re: Bar offset

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

Not applicable

Re: Bar offset

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.

Community Browser