Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Quick answer is IntervalMatch
Here you can find more advanced approach http://community.qlik.com/forums/t/23510.aspx