topic Re: Time Series Chart in QlikView

Time Series Chart

Anonymous — Mon, 20 Oct 2014 13:17:44 GMT

Hi All,

I have a requirement where i need to represent a single project details on a chart as shown in the attached image.

The Project details gets updated every week.It has the below Details.

ProjectName

Start Date

End Date

Phase End Date

Release Date

Quarter

Reload Date

As the details are getting updated weekly, Due to some reasons The Phase End Date or Release Date or Quarter may change than the actual dates.

Now the requirement is to create a bar which indicates the duration of the project(Similar to Gantt) and also if there is change in the Phase End Date or Release Date or Quarter then a marker should be placed on the bar indicating that the value has been changed on this paricular Reload date.

I have the same solution for these in 2 seperate charts i.e. one chart indicating the Project duaration and one more chart that shows the date on which the Date fields have changed.

But I m not able to show both the things in the same chart.Could anyone help in doing this?

Thanks in Advance

Re: Time Series Chart

Anonymous — Thu, 23 Oct 2014 13:49:03 GMT

HI Experts,

Any idea how we can achieve this?

Re: Time Series Chart

Jason_Michaelides — Thu, 23 Oct 2014 14:02:52 GMT

Can you provide some example data?

Re: Time Series Chart

Anonymous — Thu, 23 Oct 2014 14:16:13 GMT

Here is the Sample Data:

Project Name	Reload Date	Release Date	Quarter	Phase End Date
ABCD	24/07/2014	0	0	0
ABCD	25/07/2014	0	0	0
ABCD	29/07/2014	0	0	0
ABCD	04/08/2014	0	0	0
ABCD	11/08/2014	0	0	0
ABCD	18/08/2014	0	0	0
ABCD	25/08/2014	0	0	1
ABCD	01/09/2014	0	0	1
ABCD	08/09/2014	0	0	0
ABCD	15/09/2014	0	1	0
ABCD	19/09/2014	0	0	1
ABCD	30/09/2014	1	0	1
Start Date of the project	27/05/2014
End Date of the project	15/01/2015

if u see the image the grey color bar:is based on the Start Date and End Date

and

the thin bars is based should be shown wherever the Release Date or Quarter or Phase End Date is 1.