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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

data load - values from another table

Hi All,

Not sure if this is possible...

I have a table with a date range for each record:

table 1
IDDate1Date2
record111/01/201115/01/2011
record215/06/201131/07/2011

I have a second table with event dates:

table2
Event_Date
12/01/2011
14/01/2011
17/06/2011
30/06/2011
05/07/2011

What I want to do is create a new table, from table1 but with a new column showing how many event dates from table2 exist between Date1 & Date2:

table3
IDDate1Date2Events
record111/01/201115/01/20112
record215/06/201131/07/20113

Any advice would be much appreciated.

Regards,

Phil

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hei

actualy there is a solution it called interval match

have a look at the example file script and tables erd

hope it helps you

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hei

actualy there is a solution it called interval match

have a look at the example file script and tables erd

hope it helps you

Not applicable
Author

Thank you so much for this... what a great solution!

Kind Regards,

Phil