Discussion board where members can get started with QlikView.
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
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?
Intervalmatch can help here.
Load StartDate, EndDate, Type
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.
I have tried in another applikation and the script seems like this:
DROP Table tmp_FIA_Hierarki;
Load FIA_FLTDATEFROM, FIA_FLTDATETO, FIA_KEY
And the result is like this:
Can you see whats wrong?