Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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