Count Days In A Transaction Using Intervalmatch - Qlik Sense
Version 1, Dec 5, 2013

  Count Days In A Transaction Using Intervalmatch - QlikView
Version 1, Dec 5, 2013

This example demonstrates using IntervalMatch to count the number of days in a transaction. The transaction days could be calculated in the script by computing EndDate-StartDate, but using IntervalMatch allows for flexible counting of subtotals across various date dimensions such as Month or Quarter.

The example data is for a rental company that rents out equipment. The input data is:
EquipmentId, DateOut, DateIn