Count Days In A Transaction Using Intervalmatch

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 4836 times
Category Scripting
Tags IntervalMatch

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



Recipes for Qlikview Success