topic Re: Working with Calendar and creating a Timeline in QlikView

Working with Calendar and creating a Timeline

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I´m trying to create a timeline where it shoudl be displayed important dates from my database according to the real time.

So, for instance, the timeline will display the Years, and some important event dates from my database:

Fields:

Event 1 = 01/07/2010

Event 2 = 10/12/2015

Event 3 = 18/09/2018

The timeline should be able to display the dates above according to the real time, (past, present and future), and the user will view where are the Events 1, 2 and 3 relataded from today´s date.

Doubts:

How should i create the Min Date and Max Date for the timeline, since my dates can be updated anytime in the database. So the timeline should be able to set the Min and Max Date according with the dates that will be displayed.

What type of chart is better to displayd this kind of situation?

Regards,

Re: Working with Calendar and creating a Timeline

sunny_talwar — Wed, 13 Apr 2016 14:19:26 GMT

Is this something you are trying on the front end of the application?

Re: Working with Calendar and creating a Timeline

Wed, 13 Apr 2016 14:21:33 GMT

Yes, the user needs a friendly view of the dates represented in a timeline.

Something like that:

Re: Working with Calendar and creating a Timeline

sunny_talwar — Wed, 13 Apr 2016 14:23:59 GMT

I am guessing that Events are also inputted on the front end. if that is true, you can use the Min() and Max() from your inputted value to frame your timeline. I am not entirely sure how you plan on displaying the information, but this is just an idea.

If you have a qvw you can share or elaborate a little more, may be one of us can offer a better solution.

Re: Working with Calendar and creating a Timeline

Wed, 13 Apr 2016 14:30:45 GMT

Actually, all Events dates comes from an excel file, so i will use the fields from this Excel to display the dates in the timeline. I just need to set up a timeline and display the events dates in the right position according with the time. The timeline should be able to display the Event1 date (01/07/2010) above the 2010 position of the timeline, the Event 2 (10/12/2015) should be right above 2015 of the timeline, and so go on...

Re: Working with Calendar and creating a Timeline

swuehl — Wed, 13 Apr 2016 14:53:00 GMT

Something like a Gantt chart?

Recipe for a Gantt chart

MS Project style Team Planner view

Re: Working with Calendar and creating a Timeline

Wed, 13 Apr 2016 20:00:07 GMT

It is similar on the examples given, but my case i don´t have a period (initial date and final date).

I just need to display the exactly date for the events.

Re: Working with Calendar and creating a Timeline

swuehl — Wed, 13 Apr 2016 20:04:53 GMT

If you need to create an interval, you can do it like

Creating a Date Interval from a Single Date

Maybe you can also just use a (line) chart with continuous axis and using a symbol with values on data point to display your events.

Re: Working with Calendar and creating a Timeline

Thu, 14 Apr 2016 16:59:50 GMT

Thanks for you answer swuehl !!

Actually i don´t need to create an interval... I just need a timeline starting in a specific year (ie 2008) and ending in antoher specific date (ie 2020). The events dates should be displayed in the right position of the year informed in the database (csv).

Supposing the EVENT XPTO is in 01/07/2012, i would have somenthing like that:

But i have more than one event to display in the timeline... I am not sure if i can use the chart above, maybe in this type of chart it is possible to display only one single date with the black line.

Hope it is clearer and thanks again for the help!

Regards

Re: Working with Calendar and creating a Timeline

swuehl — Fri, 15 Apr 2016 17:12:56 GMT

Maybe using a line / combo chart?

edit:

Re: Working with Calendar and creating a Timeline

johnw — Sat, 16 Apr 2016 00:06:41 GMT

If I understood, I did something like this once with a line chart. In my case, each event had a start and end timestamp, but the end of one event was the start of the next. That may be your case as well. So I made the dimension my start timestamp, my expression was 1, and then my background color depended on the type of event.

pick(match(only({1} "Activity Type"),'Wrap','Rewrap','Idle','Delay','Unscheduled')
,rgb(38,164,38)
,rgb(255,205,155)
,rgb(152,231,152)
,rgb(234,106,106)
,rgb(235,235,235))

I used a fake legend to link those colors to the activity types, so that was my version of labeling the events. I used a very thick line, of course. Looks like I used a continuous axis and used this as my min and max date.

min({<[$(=concat({1<$Table-={'Calendar'},$Field-={'Start'}>} distinct $Field,']=,['))]=>} Start)
max({<[$(=concat({1<$Table-={'Calendar'},$Field-={'Start'}>} distinct $Field,']=,['))]=>} Start)

Not sure at the moment why I did that. Sorted by Start in ascending order.

As I recall, I'd previously done it as a stacked bar chart and event durations, but then something went wrong and that stopped working and I had to switch to a line chart.

Here, I applied the basic idea to swuehl's example.