Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chrisevans_cj
Contributor III
Contributor III

Multiple Tables with Start End - Calendar Link

Greetings,

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.

Any ideas?

0 Replies