Joint two tables with different date columns

Richies — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table that includes different dates. Startdate and enddate. Say I want to show data having a certain startdate but also have the option to only show data with an endate within the same interval. Or lets say I want to show data with both the enddate and the startdate within the interval

I have a separate table with year, month, date and a #Datekey.

Question is how to join these to tables.

If I join the two tables by using startdate as #Datekey I cannot see enddate in the selected inteval without going back to the script and change to join the tables by using endate as #Datekey instead.

There must be an easier way?

Re: Joint two tables with different date columns

Gysbert_Wassenaar — Sat, 22 Dec 2018 14:52:03 GMT

You can use the intervalmatch function: https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547

Or you can create reference dates for the intervals: https://community.qlik.com/t5/Qlik-Design-Blog/Creating-Reference-Dates-for-Intervals/ba-p/1463944

topic Re: Joint two tables with different date columns in QlikView

Joint two tables with different date columns

Re: Joint two tables with different date columns