1. 01/01/2013 - Container Moved to status 'On Hire'
2. 01/07/2013 - Container Moved to status 'Returned to Depot'
I am trying to produce a graph which, on a day by day basis shows the number of containers on hire at any one time. Therefore I need this specific container to show as on hire on everyday between 01/01/2013 and 30/06/2013 so...
Date Number of Containers on Hire
31/12/2013 0
01/01/2013 1
02/01/2013 1
03/04/2013 1
04/04/2013 1
etc etc
Does anybody know the best way to do this within Qlikview? I am unsure how to get it to show this container as on-hire from 02/01/2013 until it is returned.
Do you have a calendar setup with records for the days in question?
If you do then you can use an intervalmatch approach to create a new table with a record for day between your dates. Concatenate that table to your status table and you will have a table with a daily status value. Have fun 🙂
