topic Urgent - Help required to create a Progress Chart in QlikView

Urgent - Help required to create a Progress Chart

sayadutt — Fri, 19 Feb 2016 07:40:35 GMT

Hello Team,

I have the following columns already loaded in qvw. I want to create a Progress chart (over the time period) to show the progress.

Table:

ProjectName RequirementExpectedDate RequirementActualDate ProjectGoLiveDate

xxx 1/1/2016 1/15/2016 2/15/2016

yyy 2/10/2015 2/10/2015 2/1/2015

zzz 11/11/2015 11/12/2015 11/20/2015

Now my requirement is to show how the difference of RequirementExpectedDate and RequirementActualDate has progressed over the period (ProjectGoLiveDate).

X-Axis should show the date difference (in numbers) in Percentage.

Y -Axis should show the GoLiveMonths

Can you all please guide me.

Thanks

Re: Urgent - Help required to create a Progress Chart

Peter_Cammaert — Fri, 19 Feb 2016 08:04:51 GMT

Maybe you should first fix your dates. Project xxx has a ProjectGoLiveDate of 2/15/2016 and project zzz has a PrjectGoLiveDate of 29/11/2015. You can't have it both ways (you can, but it's better to fix what is wrong)

Peter

Re: Urgent - Help required to create a Progress Chart

sayadutt — Fri, 19 Feb 2016 08:10:57 GMT

Hi Peter,

That was a typo. I have fixed it. Can you guide here.

Thanks in advance!!!

Re: Urgent - Help required to create a Progress Chart

Peter_Cammaert — Fri, 19 Feb 2016 08:14:48 GMT

Based on your minimal details, this is what I came up with. Is this what you want?

Best,

Peter

Re: Urgent - Help required to create a Progress Chart

sayadutt — Fri, 19 Feb 2016 08:20:47 GMT

Can we have x-axis in Percentage please.

The differnce should be Actual minus Expected, so always positive or zero. (not negative)

Also, can we apply NetWorkDays function.. instead of avg, so that we get only the working dayscount excluding weekends.

Thanks

Re: Urgent - Help required to create a Progress Chart

PradeepReddy — Fri, 19 Feb 2016 10:32:53 GMT

can you elaborate your requirement..

X-Axis (numbers in %) --> what % you want to showcase?

Y-Axis (GoLiveMonths) --> how you are calculating this