topic Re: How to avoid overlap values in a Timeline? in QlikView

How to avoid overlap values in a Timeline?

Wed, 25 Nov 2020 16:16:04 GMT

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:

So i have a Time Line between 2010 and 2020:

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:

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!

Re: How to avoid overlap values in a Timeline?

swuehl — Tue, 31 May 2016 21:55:17 GMT

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

Re: How to avoid overlap values in a Timeline?

Thu, 02 Jun 2016 19:05:28 GMT

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:

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

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":

Do you know where is the issue?

Thanks again!

Re: How to avoid overlap values in a Timeline?

swuehl — Thu, 02 Jun 2016 22:33:29 GMT

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

Please check attached version.