topic Overlapping time periods (Start Date &amp; End Date) in Management & Governance https://community.qlik.com/t5/Management-Governance/Overlapping-time-periods-Start-Date-amp-End-Date/m-p/1948957#M22567 <P>Hi Community.</P> <P>&nbsp;</P> <P>I am having a challenge with my source data where I would be more than happy about a swift solution.</P> <P>I get informaton with the following information:</P> <P>&nbsp;</P> <P>LeadID | Lead | Status | Start Date | End Date</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Open&nbsp; | 20.01.2022 | 20.01.2022</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Qual&nbsp; | 20.01.2022 | 25.01.2022</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Qual&nbsp; | 25.01.2022 | 25.01.2022</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Conv&nbsp; | 25.01.2022 | 30.01.2022<BR /><BR />What I need to analyze and merge it to my Master Calendar is the following structure</P> <P>LeadID | Lead | Status | Start Date | End Date</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Open&nbsp; | 20.01.2022 | 20.01.2022 (This line will be deleted) as duplicate</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Qual&nbsp; | 20.01.2022 | 24.01.2022 (End Date Adjusted from 25.01.2022 to 24.01.2022</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Qual&nbsp; | 25.01.2022 | 25.01.2022&nbsp;This line will be deleted) as duplicate</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Conv&nbsp; | 25.01.2022 | 30.01.2022</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>My Status can have a value to show only the ones with the highest value in case of overlaps, like with 1st line where Status = "Open"</P> <P><BR /><BR /></P> Tue, 28 Jun 2022 09:22:18 GMT MME2 2022-06-28T09:22:18Z Overlapping time periods (Start Date & End Date) https://community.qlik.com/t5/Management-Governance/Overlapping-time-periods-Start-Date-amp-End-Date/m-p/1948957#M22567 <P>Hi Community.</P> <P>&nbsp;</P> <P>I am having a challenge with my source data where I would be more than happy about a swift solution.</P> <P>I get informaton with the following information:</P> <P>&nbsp;</P> <P>LeadID | Lead | Status | Start Date | End Date</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Open&nbsp; | 20.01.2022 | 20.01.2022</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Qual&nbsp; | 20.01.2022 | 25.01.2022</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Qual&nbsp; | 25.01.2022 | 25.01.2022</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Conv&nbsp; | 25.01.2022 | 30.01.2022<BR /><BR />What I need to analyze and merge it to my Master Calendar is the following structure</P> <P>LeadID | Lead | Status | Start Date | End Date</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Open&nbsp; | 20.01.2022 | 20.01.2022 (This line will be deleted) as duplicate</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Qual&nbsp; | 20.01.2022 | 24.01.2022 (End Date Adjusted from 25.01.2022 to 24.01.2022</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Qual&nbsp; | 25.01.2022 | 25.01.2022&nbsp;This line will be deleted) as duplicate</P> <P>123&nbsp; &nbsp; &nbsp; &nbsp;| Test | Conv&nbsp; | 25.01.2022 | 30.01.2022</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>My Status can have a value to show only the ones with the highest value in case of overlaps, like with 1st line where Status = "Open"</P> <P><BR /><BR /></P> Tue, 28 Jun 2022 09:22:18 GMT https://community.qlik.com/t5/Management-Governance/Overlapping-time-periods-Start-Date-amp-End-Date/m-p/1948957#M22567 MME2 2022-06-28T09:22:18Z