https://community.qlik.com/t5/QlikView/Find-the-Difference-Time/m-p/1568843#M441937 <PRE>&nbsp;</PRE><P>&nbsp;</P><PRE><SPAN>The table below, I need to find and add up the difference.</SPAN></PRE><P>Placa = 'LSP1241',Type(Chegado) ('11/01/2019 13:58:44', 'DD/MM/YYYY hh:mm:ss') - Placa = 'LSP1241',Type(Saindo) ('11/01/2019 14:32:53' ,'DD/MM/YYYY hh:mm:ss')</P><PRE><SPAN>How would this set analysis</SPAN></PRE><TABLE><TBODY><TR><TD>Placa</TD><TD>Date</TD><TD>Type</TD></TR><TR><TD>LSP1241</TD><TD>11/01/2019 13:58:44</TD><TD>Chegando</TD></TR><TR><TD>LSP1241</TD><TD>11/01/2019 14:32:53</TD><TD>Saindo</TD></TR><TR><TD>LVO7376</TD><TD>11/01/2019 15:26:28</TD><TD>Chegando</TD></TR><TR><TD>LVO7376</TD><TD>11/01/2019 15:51:20</TD><TD>Saindo</TD></TR><TR><TD>NHV8442</TD><TD>11/01/2019 12:31:31</TD><TD>Chegando</TD></TR><TR><TD>NHV8442</TD><TD>11/01/2019 13:44:56</TD><TD>Saindo</TD></TR><TR><TD>NIC6747</TD><TD>11/01/2019 10:20:43</TD><TD>Chegando</TD></TR><TR><TD>NIC6747</TD><TD>11/01/2019 10:27:35</TD><TD>Saindo</TD></TR></TBODY></TABLE><P>&nbsp;</P> Fri, 12 Apr 2019 15:19:09 GMT Ribeiro 2019-04-12T15:19:09Z https://community.qlik.com/t5/QlikView/Find-the-Difference-Time/m-p/1568843#M441937 <PRE>&nbsp;</PRE><P>&nbsp;</P><PRE><SPAN>The table below, I need to find and add up the difference.</SPAN></PRE><P>Placa = 'LSP1241',Type(Chegado) ('11/01/2019 13:58:44', 'DD/MM/YYYY hh:mm:ss') - Placa = 'LSP1241',Type(Saindo) ('11/01/2019 14:32:53' ,'DD/MM/YYYY hh:mm:ss')</P><PRE><SPAN>How would this set analysis</SPAN></PRE><TABLE><TBODY><TR><TD>Placa</TD><TD>Date</TD><TD>Type</TD></TR><TR><TD>LSP1241</TD><TD>11/01/2019 13:58:44</TD><TD>Chegando</TD></TR><TR><TD>LSP1241</TD><TD>11/01/2019 14:32:53</TD><TD>Saindo</TD></TR><TR><TD>LVO7376</TD><TD>11/01/2019 15:26:28</TD><TD>Chegando</TD></TR><TR><TD>LVO7376</TD><TD>11/01/2019 15:51:20</TD><TD>Saindo</TD></TR><TR><TD>NHV8442</TD><TD>11/01/2019 12:31:31</TD><TD>Chegando</TD></TR><TR><TD>NHV8442</TD><TD>11/01/2019 13:44:56</TD><TD>Saindo</TD></TR><TR><TD>NIC6747</TD><TD>11/01/2019 10:20:43</TD><TD>Chegando</TD></TR><TR><TD>NIC6747</TD><TD>11/01/2019 10:27:35</TD><TD>Saindo</TD></TR></TBODY></TABLE><P>&nbsp;</P> Fri, 12 Apr 2019 15:19:09 GMT https://community.qlik.com/t5/QlikView/Find-the-Difference-Time/m-p/1568843#M441937 Ribeiro 2019-04-12T15:19:09Z https://community.qlik.com/t5/QlikView/Find-the-Difference-Time/m-p/1569032#M441955 In a table containing the dimension Placa you could probably use this expression.<BR /><BR />Only({&lt;Type={'Saindo'}&gt;}Date) - Only({&lt;Type={'Chegando'}&gt;}Date) Sun, 14 Apr 2019 10:41:25 GMT https://community.qlik.com/t5/QlikView/Find-the-Difference-Time/m-p/1569032#M441955 Vegar 2019-04-14T10:41:25Z