Interval match for two ranges/criteria

sibrulotte — Tue, 03 Nov 2015 20:16:43 GMT

Hi,

I have a table that has job titles for a slew of people with dates where they started and ended:

LOAD * INLINE [

NAME, Start, End, JOB_CODE

Jeff, 2010-10-01, 2012-09-30, CHIEF

Jeff, 2012-10-01, , BIG_CHIEF

Garfield, 2011-10-01, 2013-09-30, BALLER

Garfield, 2013-10-01, 2014-06-01, LOW_BALLER

];

I have Expense accounts and I want to know their job code when they made this expense:

LOAD * INLINE [

NAME, DESCRIPTION, DATE, EXP_ID

Jeff, Headress, 2012-06-01, 1

Jeff, Funky shoes, 2014-01-01, 2

Garfiled, Lasagna, 2011-11-30, 3

Garfield, Pizza, 2013-11-30, 4

];

I would end up with something like:

NAME, DESCRIPTION, DATE, EXP_ID, JOB_CODE

Jeff, Headress, 2012-06-01, 1, CHIEF

Jeff, Funky shoes, 2014-01-01, 2, BIG_CHIEF

Garfiled, Lasagna, 2011-11-30, 3, BALLER

Garfield, Pizza, 2013-11-30, 4, LOW_BALLER

];

Just an interval match doesn't work because I have more than one criteria. I was wondering if it was an issue of createit fit in an interval match function...

Any help here understanding the interval match possibilities?

Re: Interval match for two ranges/criteria

sinanozdemir — Tue, 03 Nov 2015 21:10:07 GMT

Hi Simon,

Sorry. My first attachment had a misspelling in the name. The below should work for you:

topic Interval match for two ranges/criteria in QlikView

Interval match for two ranges/criteria

Re: Interval match for two ranges/criteria