Qlik average time calculator

[wanass123]

Hello everyone 

Please I have below data example and I need to create KPI with average time when : 

Ticket transferred from Level3 to Level2 And Team from Support Team to Retail Manager for the same ticket 

in below example result is :  ( 1/3/2020 14:52 ) - ( 1/2/2020 9:56 ) = 1.205 Days = 28.92 Hours ( by excel ) 

Ticket ID	Created	user	Type	Team from	Team To	Level
5-12243	1/2/2020 9:56	User31	Owner Group	Support Team	Retail Manager	Level3
5-12244	1/3/2020 14:52	User453	Owner Group	Retail Manager	Support Team	Level2

How I can do this calculation in Qlik difference between two lines times , with this specific conditions   

Thanks in advance .

[PriyankaShivhare]

add one more measure in table with expression above(created)
then use interval function to calculate the difference

thanks,
Priyanka

[Anil_Babu_Samineni]

Can you please share 10 rows and explain the output?

[wanass123]

I found the solution thank you very much 

solution : 

NoConcatenate
RetailData:
Load *, if((Team To) = 'Retail Manager ', Interval(Previous(CREATED)-(CREATED),'HH')) as Pendingtime
Resident RetailData ;
Drop table RetailData;