Check if an Order is active on a specific date

Anonymous — Thu, 25 Oct 2012 12:32:42 GMT

I need some help with a problem I have been struggling with.

In a rental shop I have rental orders with at CreatedDate, StartDate and EndDate. At the moment there is a join between CreatedDate and Date in the MasterCalender.

My challenge is to make a chart that shows me how many active Orders on given dates/periods back in time.

It’s important to be aware that not all orders have a DateEnd value since it’s still active and also that if a period is selected, orders with a StartDate before the selected period could be active in some or all the selected period.

I really hope someone can help me.

topic Check if an Order is active on a specific date in QlikView

Check if an Order is active on a specific date