Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Lookup between FROM and TO dates

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

Tags (2)
4 Replies
Partner
Partner

Re: Lookup between FROM and TO dates

Intervalmatch can help here.

Re: Lookup between FROM and TO dates

Intervalmatch(Date, Type)

Load StartDate, EndDate, Type

Resident Dim_Type;

Not applicable

Re: Lookup between FROM and TO dates

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.

Not applicable

Re: Lookup between FROM and TO dates

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