https://community.qlik.com/t5/App-Development/Subtract-timestamp/m-p/1787883#M61494 <P>Hello everyone,</P><P>I want to fetch Interval between 2 different dates with one customer id.</P><P>Please look into the image for a quick overview.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Neeraja005_2-1614770267274.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/50359iC2937C1644D84412/image-size/medium?v=v2&amp;px=400" role="button" title="Neeraja005_2-1614770267274.png" alt="Neeraja005_2-1614770267274.png" /></span></P><P>&nbsp;</P><P>I have 2 types for one customer&nbsp; type='Q' and 'A'</P><P>I need to subtract the approved date with type Q&nbsp; and create_date&nbsp; with type A&nbsp; where appointment_date for both = Nul or 0</P><P><U><EM>I am trying to use the following formula:&nbsp;</EM></U></P><P>&nbsp;</P><LI-SPOILER><STRONG>=Interval((if (type='Q' and customer_id=customer_id and (len(Trim(appointment_date))=0),approvedAt))-(if (type='A' and customer_id=customer_id and (len(Trim(appointment_date))=0),[message.createdAt])),'D hh:mm')</STRONG></LI-SPOILER><P>&nbsp;</P><P>Can someone please help me with this. Anykind of information would be helpful</P><P>TIA</P><P>&nbsp;</P><P>Regards,</P><P>Neeraja Upadrasta</P> Sat, 16 Nov 2024 17:25:43 GMT Neeraja005 2024-11-16T17:25:43Z https://community.qlik.com/t5/App-Development/Subtract-timestamp/m-p/1787883#M61494 <P>Hello everyone,</P><P>I want to fetch Interval between 2 different dates with one customer id.</P><P>Please look into the image for a quick overview.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Neeraja005_2-1614770267274.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/50359iC2937C1644D84412/image-size/medium?v=v2&amp;px=400" role="button" title="Neeraja005_2-1614770267274.png" alt="Neeraja005_2-1614770267274.png" /></span></P><P>&nbsp;</P><P>I have 2 types for one customer&nbsp; type='Q' and 'A'</P><P>I need to subtract the approved date with type Q&nbsp; and create_date&nbsp; with type A&nbsp; where appointment_date for both = Nul or 0</P><P><U><EM>I am trying to use the following formula:&nbsp;</EM></U></P><P>&nbsp;</P><LI-SPOILER><STRONG>=Interval((if (type='Q' and customer_id=customer_id and (len(Trim(appointment_date))=0),approvedAt))-(if (type='A' and customer_id=customer_id and (len(Trim(appointment_date))=0),[message.createdAt])),'D hh:mm')</STRONG></LI-SPOILER><P>&nbsp;</P><P>Can someone please help me with this. Anykind of information would be helpful</P><P>TIA</P><P>&nbsp;</P><P>Regards,</P><P>Neeraja Upadrasta</P> Sat, 16 Nov 2024 17:25:43 GMT https://community.qlik.com/t5/App-Development/Subtract-timestamp/m-p/1787883#M61494 Neeraja005 2024-11-16T17:25:43Z