Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser22
Creator II
Creator II

Join a table with Calendar table without Date field

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: 

qlikuser22_1-1692791536663.png

Sample Data: 
Table1:

qlikuser22_0-1692799091414.png

Table2: 

qlikuser22_1-1692799136049.png

 

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!

 

Labels (3)
1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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!