Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

generating data between a date range

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

1 Reply
DavidFoster1
Specialist
Specialist

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 🙂