Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ribeiro
Specialist
Specialist

Find the Difference Time

 

 

The table below, I need to find and add up the difference.

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')

How would this set analysis
PlacaDateType
LSP124111/01/2019 13:58:44Chegando
LSP124111/01/2019 14:32:53Saindo
LVO737611/01/2019 15:26:28Chegando
LVO737611/01/2019 15:51:20Saindo
NHV844211/01/2019 12:31:31Chegando
NHV844211/01/2019 13:44:56Saindo
NIC674711/01/2019 10:20:43Chegando
NIC674711/01/2019 10:27:35Saindo

 

Neves
1 Solution

Accepted Solutions
Vegar
MVP
MVP

In a table containing the dimension Placa you could probably use this expression.

Only({<Type={'Saindo'}>}Date) - Only({<Type={'Chegando'}>}Date)

View solution in original post

1 Reply
Vegar
MVP
MVP

In a table containing the dimension Placa you could probably use this expression.

Only({<Type={'Saindo'}>}Date) - Only({<Type={'Chegando'}>}Date)