Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
marius_larsen
Contributor II

Intervalmatch Extended

I have a problem with the intervalmatch extended syntax,

see attached file.

it dosent get the tartildato correct when i connect both tables with an intervalmatch.

seems like the problem is that it matches TARIFFRADATO with both LEVFRADATO and LEVTILDATO.

Levfradato and levtildato is the datekey.

syntax:

inner join

IntervalMatch (%DateKey, Kundekontrakt) LOAD TARIFFFRADATO,TARIFFTILDATO,Kundekontrakt,EKSTERNTRESEPTNAMN resident Produktbytte;

Output in QV:

TaptVunnettable:

Produktbyttetable: