Create Timeline for activities based on start- and enddate

dickelsa — Tue, 04 Mar 2014 18:36:53 GMT

Hello all,

I am dealing with an issue at the moment.

currently I am building a dashboard that should function as a timeline. with this I mean: I have a few activities that are linked to a startdate. the startdate from the second activity however, is the enddate of the first activity.

the following example should explain it:

given is the following table:

activity	date
talking	1-1-2013
drinking	20-1-2013
eating	22-2-2013
running	12-5-2014
sleeping	2-6-2014

now the activity 'Talking' starts at 1-1-2013 and ends at 20-1-2013, because then the activity 'Drinking' starts. The activity 'Drinking' ends on 22-2-2013 because then the activity 'eating' starts and so on.

so when I should click the date 15-1-2013, the activity 'talking' should be activated, and so on

I currently have this, but I cant figure out what to do.

Can you guys help me?

Thanks in advance,

Dick

Re: Create Timeline for activities based on start- and enddate

MK_QSL — Tue, 04 Mar 2014 19:44:24 GMT

Please check enclosed file for your answer...

topic Create Timeline for activities based on start- and enddate in QlikView

Create Timeline for activities based on start- and enddate

Re: Create Timeline for activities based on start- and enddate