Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

dickelsa
Contributor

Create Timeline for activities based on start- and enddate

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:

activitydate
talking1-1-2013
drinking20-1-2013
eating22-2-2013
running12-5-2014
sleeping2-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

1 Solution

Accepted Solutions

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

Please check enclosed file for your answer...

1 Reply

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

Please check enclosed file for your answer...

Community Browser