topic Re: Line Graph in QlikView

Line Graph

Mon, 22 Feb 2016 12:54:04 GMT

Hi All,

I am trying to create the following line graph:

Where Number of Completed Work Orders are compared to the Avg days to complete those work orders with the points your see above.

Avg Days # of Work Orders

5 100

30 76

60 40

90 20

100 10

I know I have seen this done in a post but cant locate it right now. Any help would be awesome.

Thanks,

David

Re: Line Graph

sunny_talwar — Mon, 22 Feb 2016 12:58:04 GMT

Is Avg days coming from your data? or is that a calculated dimension?

Re: Line Graph

Mon, 22 Feb 2016 13:02:47 GMT

It is a calculated field in my load statement:

NetWorkDays(RequestDate,ActualCompletionDate)) as DaysAged,

I am also using:

Interval(ActualCompletionDate-[RequestDate],'D') as DaysToComplete,

David

Re: Line Graph

sunny_talwar — Mon, 22 Feb 2016 13:08:44 GMT

If everything is precalculated in the script, then may be as attached

Re: Line Graph

Mon, 22 Feb 2016 13:13:08 GMT

Did you use # Completed Work Tickets as the dimension and Completed Ticket as Expression?

Re: Line Graph

Mon, 22 Feb 2016 13:21:45 GMT

Sorry I did not see your attachment. The number of work orders is not stored in the Load statement.

David

Re: Line Graph

sunny_talwar — Mon, 22 Feb 2016 13:24:48 GMT

Would you be able to share some raw data? Aggregated data makes it difficult to get a sample across.

Re: Line Graph

Mon, 22 Feb 2016 13:39:01 GMT

I have attached my file. Let me know if this makes sense.

Re: Line Graph

sunny_talwar — Mon, 22 Feb 2016 14:05:29 GMT

How would you go about calculating # of Work Days based on DaysAged dimension?

Re: Line Graph

Mon, 22 Feb 2016 15:07:37 GMT

This is how I do it in a straight table. I am trying to figure out how to do it in a graph.

Re: Line Graph

fonmarcelo — Tue, 23 Feb 2016 14:05:10 GMT

It is?