topic Re: Timeline in QlikView

Timeline

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a timeline in my project, but the dates overlap, is there any way to fix this?

Grateful

Re: Timeline

Chanty4u — Fri, 15 Apr 2016 17:12:32 GMT

u can press Cntrl+shift to move ur timeline or charts from with in chrt try this

Re: Timeline

Anonymous — Fri, 15 Apr 2016 17:45:12 GMT

Hi, Thanks,

this does not work, I'm sending a sample to see if it helps.

Re: Timeline

Chanty4u — Fri, 15 Apr 2016 18:07:54 GMT

u can change the chart style to horizental

Re: Timeline

Chanty4u — Fri, 15 Apr 2016 18:15:08 GMT

bcz ur chart expression dates all are in same year so the dates is shwng in same point...its too clumsy.

better u convert the chart to see the dates

Re: Timeline

swuehl — Fri, 15 Apr 2016 18:41:22 GMT

Maybe something along this?

Re: Timeline

swuehl — Fri, 15 Apr 2016 19:12:05 GMT

Attached another version, using a more sophisticated calculation to stack events vertically.

You can adjust the EventGroup calculation in the script to set max number of Events stacked vertically and the event proximity used for grouping.

Re: Timeline

Anonymous — Thu, 19 May 2016 20:36:13 GMT

Thanks for your help swuehl !

In my case, i have 4 columns in my database (xlsx), which it is the dates that i want to display in my chart.

How can i use these 4 fields of my database in this script that you shared??

It seems you are setting fix dates or aleatory dates in your script and showing in your chart.

In my project, i need to display the dates that come from my database, and could be changed anytime, depending on the selection of filters that user will apply.

Below you can see how i am using the fields of my data base in the expressions of my timeline chart:

Does it make sense for you?

If not, i can share my qvw to help.

Many thanks!

Re: Timeline

swuehl — Tue, 31 May 2016 22:10:36 GMT

Maybe like this