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:
Filename
QCB-Count-Days-in-a-Transaction-Using-IntervalMatch.qvf
Filesize
224 KB
version
1 - Qlik Sense
1 - QlikView Previous versions
Date added
Dec 5, 2013
Downloaded
6144 times
Category
Scripting
Tags
IntervalMatch
EquipmentId, DateOut, DateIn