Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Delimit a timeline between two dates.

Hello,

I have a database like this: Machine / BeginDate / EndDate, Where  ( EndDate - BeginDate ) is the activity time of a machine in a order

production.

What I want is to show in a timeline the total activity between two dates.

For example:

machine1 | 10/10/2015 23:00:00 | 14/10/2015 21:00:00

machine2 | 13/10/2015 9:00:00 | 18/10/2015 17:30:00

I want to see the occupation between day " 13/10/2015 12:00:00 " and " 16/10/2015 23:00:00 "

In the timeline should be the time of occupation of the two machines in that time zone , and this would be:

Machine1 : 13/10/2015 12:00:00 to 14/10/2015 21:00:00

Machine2 : 13/10/2015 12:00:00 to 16/10/2015 23:00:00

To do this I 'm using google timeline as shown in the image, but this only allows me to filter by dimension .

How can i fix the problem ?

There is some extension for that purpose ?

Greetings and thank you.

TimeLine.JPG

0 Replies