let's say I've Drivers and Cars tables and a third table which relate them.Something like this:
Driver Car StartDate EndDate
Sam AB123 2010-10-01 2011-01-31
I've also a Mileage table like this
Car Date Km
AB123 2011-01-01 110
AB123 2011-01-02 90
How can I model this in QlikView? How can I create an expression to show the total mileage of Sam while he was driving AB123 (that is, with Date between StartDate and EndDate)?