Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connecting From and To date to the master calender which is having only on field

Hi All,

Many of the tables in my document is having from and to date. I have master calender in the same document. I want to connect the date from master calender with all those tables which is having date in from and to range and both the fields are separately given.

Also If this is done then data should be filtered according to the selected date. For example, If I am selecting any dates which is in between from and to date. It should give all those details who are in that range. If I select the range of dates then it should give the result of all the values which falls under the selected range.

Also how to take care of synthetic key which may happen here.

Hope some one can help me out!

1 Reply
Not applicable
Author

Quick answer is IntervalMatch

Here you can find more advanced approach http://community.qlik.com/forums/t/23510.aspx