generating data between a date range

Wed, 04 Sep 2013 13:22:19 GMT

Hi There

I have two lines in a table in my database:

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.

Any help is much appreciated!

Thanks,

Steve

Re: generating data between a date range

DavidFoster1 — Wed, 04 Sep 2013 15:50:40 GMT

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 🙂

topic generating data between a date range in QlikView

generating data between a date range

Re: generating data between a date range