Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

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

Quick answer is IntervalMatch

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