Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dickelsa
Creator
Creator

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
MK_QSL
MVP
MVP

Please check enclosed file for your answer...

View solution in original post

1 Reply
MK_QSL
MVP
MVP

Please check enclosed file for your answer...