Search Recipes > IntervalMatch (1)

Count Days In A Transaction Using Intervalmatch

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

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

 

Share
Share

 

Recipes for Qlikview Success