topic Lookup between FROM and TO dates in QlikView

Lookup between FROM and TO dates

Thu, 15 Jan 2015 21:40:40 GMT

HI!

Im not an experienced QlikView developer so wonder if somebody out there can help.

I have one table with TICKETS and the fields TYPE and DATE

The other table DIM_TYPE containes TYPE, DESCRIPTION, STARTDATE and ENDDATE

I need to make an "lookup" from TICKETS to DIM_TYPE

Where

TYPE = TYPE

DATE BETWEEN STARTDATE and ENDDATE

I want to add the DESCRIPTION field to TICKETS or create a PRIMARYKEY in the tables so that i can link them together.

I guess this is possible but i dont know how.

Somebody that can help?

Rune

Re: Lookup between FROM and TO dates

jonasheisterkam — Thu, 15 Jan 2015 21:43:59 GMT

Intervalmatch can help here.

Re: Lookup between FROM and TO dates

MarcoWedel — Thu, 15 Jan 2015 21:44:33 GMT

Intervalmatch(Date, Type)

Load StartDate, EndDate, Type

Resident Dim_Type;

Re: Lookup between FROM and TO dates

Fri, 16 Jan 2015 14:31:55 GMT

Thank you for the tips!

It seems that this function should solve my problem but i can get to work.

I get som syntetic connections so the way i have written it so far is not ok.

Re: Lookup between FROM and TO dates

Fri, 16 Jan 2015 15:05:39 GMT

Hi again!

I have tried in another applikation and the script seems like this:

Pax_Rev_Details:

LOAD

FLTNUM,

FIA_FLTDATE,

FIA_KEY,

FIA_KEY.....

FROM

[..\QVD\MisData\MISDATA_2015.qvd]

(qvd);

FIA_Hierarki:

LOAD

FIA_KEY,

FIA_FLTDATEFROM,

FIA_FLTDATETO,

FIA_...........

Resident tmp_FIA_Hierarki;

DROP Table tmp_FIA_Hierarki;

FIA_IntMatch:

Intervalmatch(FIA_FLTDATE, FIA_KEY)

Load FIA_FLTDATEFROM, FIA_FLTDATETO, FIA_KEY

Resident FIA_Hierarki;

And the result is like this:

Can you see whats wrong?

Rune