Join a table with Calendar table without Date field

[qlikuser22]

Hi,

I have two tables.

Table1:

Load
Name,
Volume,

Start_week,

End_week,

comment,

createdBy,

Start_week &'#'& End_week as week_key

from abc.csv;

Table2:

Load 

Quarter,

Date,

Week,

Month

from def.csv;

Example: 

Sample Data: 
Table1:

Table2: 

Now I want to join these two tables using some key, so that if I select Quarter = 1, then Start week and End_week should be within the range of Quarter 1. 

I am not sure how to create a key and link these two tables. 

Please need some help 🙂 

Thanks in advance!

[Oleg_Troyansky]

Hi,

This is done with the use of INTERVALMATCH load - look it up in the documentation. You will associate the ranges of Start-End with the distinct Dates, and the rest will happen based on the associative logic.

I'm describing the INTERVALMATCH logic with great detail in my book, if you'd like to check it out.

To learn more advanced development techniques, check out the agenda of the Masters Summit for Qlik - coming soon to Orlando and to Dublin!