Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to avoid overlap values in a Timeline?

Hello everyone,

I am creating a Line Chart where i want to display specific dates from my data base in a Time Line.

First i have created 2 variables to Set the minimum and maximum period:

LET vMinDate=40179;
LET vMaxDate=44196;

And than i used these variables in the scale of the chart:

Capturar.PNG

So i have a Time Line between 2010 and 2020:

Capturar.PNG

I need to display Events Dates which comes from 4 fields of my data base, and the problem is that when these dates are close, it is displayed overlaped:

Capturar.PNG

Each date is an expression in the TimeLine chart:

Only ([EU Submission date])

Only ([EU Approval date])

Only ([US Submission date])

Only ([US Approval date])

Attached is the data base and sample of my project.

Anyone could help to avoid these overlaping dates in the Time Line?

Thanks!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Yes, there was some code left over from my other sample file that messed up the dates.

Please check attached version.

View solution in original post

3 Replies
swuehl
MVP
MVP

Maybe have a looked at the stacked events display I've shown in this thread

Re: Timeline

edit: attaching a sample made of your sample data

Not applicable
Author

Hi swuehl, thanks for your answer.

After analyzing your solution,  i concluded that the TimeLine is not showing the dates from my data base, see below the dates from my data base:

Capturar.PNG

When i select the Value "A" from Details, the Time Line displays the date "05/04/2011", where it should be "06/07/2015":

Capturar.PNG

Another example, if i select the value "I" from Details, the TimeLine displays the dates "05/06/2011", "02/03/2015", "23/12/2016" and "24/10/2019", where it should be "02/12/2011", "13/03/2013", "22/02/2011" and "23/08/2012":

Capturar.PNG

Do you know where is the issue?

Thanks again!

swuehl
MVP
MVP

Yes, there was some code left over from my other sample file that messed up the dates.

Please check attached version.