https://community.qlik.com/t5/App-Development/Return-the-1st-date-AFTER-another-timestamp/m-p/1941205#M77562 <P>ok I am trying to get me Speed to lead. I can easily get it from excel but looking to move into Qlik. I am having an issue when it comes to the 1st contact AFTER the lead was renewed.</P> <P>&nbsp;</P> <P>(aggr(min(First_Timestamp_List),contactid))&nbsp; - Pulls the most recent timestamp for the lead</P> <P>(aggr(min(CallDateTime_CallLog),contactid)) -Pulls the 1st time we have a call for that lead.</P> <P>&nbsp;</P> <P>I did try&nbsp;IF(CallDateTime_CallLog&gt;=First_Timestamp_List,(aggr(min(CallDateTime_CallLog),contactid))) but this doesn't seem to take any effect in giving me the 1st time we called that lead AFTER the most recent timestamp for the lead</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 08 Jun 2022 17:00:17 GMT mattue84 2022-06-08T17:00:17Z https://community.qlik.com/t5/App-Development/Return-the-1st-date-AFTER-another-timestamp/m-p/1941205#M77562 <P>ok I am trying to get me Speed to lead. I can easily get it from excel but looking to move into Qlik. I am having an issue when it comes to the 1st contact AFTER the lead was renewed.</P> <P>&nbsp;</P> <P>(aggr(min(First_Timestamp_List),contactid))&nbsp; - Pulls the most recent timestamp for the lead</P> <P>(aggr(min(CallDateTime_CallLog),contactid)) -Pulls the 1st time we have a call for that lead.</P> <P>&nbsp;</P> <P>I did try&nbsp;IF(CallDateTime_CallLog&gt;=First_Timestamp_List,(aggr(min(CallDateTime_CallLog),contactid))) but this doesn't seem to take any effect in giving me the 1st time we called that lead AFTER the most recent timestamp for the lead</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 08 Jun 2022 17:00:17 GMT https://community.qlik.com/t5/App-Development/Return-the-1st-date-AFTER-another-timestamp/m-p/1941205#M77562 mattue84 2022-06-08T17:00:17Z