topic Multiple Tables with Start End - Calendar Link in QlikView https://community.qlik.com/t5/QlikView/Multiple-Tables-with-Start-End-Calendar-Link/m-p/1185681#M884976 <HTML><HEAD></HEAD><BODY><P>Greetings,</P><P></P><P>What would the best way be to link a Calendar with a StartDate and EndDate in multiple tables (I have 14 tables which have start and end dates in them, the tables all link on a common IDNumber) Now I need to be able to select May 2015 and show all field where MAy 2015 is between StartDate and EndDate. I've tried using IntervalMatch but for example 1 of the tables which has 35000 records returns 22000000 records which put strain on the computer's resources (6MB RAM) and that only 1 table.</P><P></P><P>Any ideas?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT chrisevans_cj 2020-11-25T16:16:04Z Multiple Tables with Start End - Calendar Link https://community.qlik.com/t5/QlikView/Multiple-Tables-with-Start-End-Calendar-Link/m-p/1185681#M884976 <HTML><HEAD></HEAD><BODY><P>Greetings,</P><P></P><P>What would the best way be to link a Calendar with a StartDate and EndDate in multiple tables (I have 14 tables which have start and end dates in them, the tables all link on a common IDNumber) Now I need to be able to select May 2015 and show all field where MAy 2015 is between StartDate and EndDate. I've tried using IntervalMatch but for example 1 of the tables which has 35000 records returns 22000000 records which put strain on the computer's resources (6MB RAM) and that only 1 table.</P><P></P><P>Any ideas?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Multiple-Tables-with-Start-End-Calendar-Link/m-p/1185681#M884976 chrisevans_cj 2020-11-25T16:16:04Z