topic Display Rental of Goods in QlikView

Display Rental of Goods

Thu, 17 Dec 2009 21:45:41 GMT

Hi,

I want to create a model that will display what items/machines are currently out on rental, what are booked for rental and what is available for rental.

Find attached an excel table of what I would like to display on Qlikview. If anybody has previously come across such a model or if you could suggest ideas of how I could overcome this I would be most grateful.

My database is a normal order processing model where the date entered, date required and date returned are all recorded.

Thanks,

Display Rental of Goods

Thu, 17 Dec 2009 22:11:31 GMT

FC,

Thanks for the example output, could you provide a few rows of example data?

Display Rental of Goods

Thu, 17 Dec 2009 22:43:13 GMT

Thanks Jason for the reply.

Find attached a very basic database but it is a simplified version of the real database so if you can manipulate this data to reflect a similar graph it would set me along the correct path.

Note: The previous graph is not reflective of this database

May thanks,

Display Rental of Goods

rwunderlich — Fri, 18 Dec 2009 13:11:32 GMT

You might find a good starting point in the Qlikview Cookbook example "Count days in a transaction using IntervalMatch". That sample usees a rental data scenario.

-Rob

Display Rental of Goods

Tue, 22 Dec 2009 00:42:35 GMT

Hi,

This is where I am at in relation to the above query, if anybody could make a suggestion or has an alternative solution it would be appreciated.

regards,