topic Qlik average time calculator in App Development

Qlik average time calculator

wanass123 — Sat, 16 Nov 2024 00:40:20 GMT

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 .

Re: Qlik average time calculator

PriyankaShivhare — Sat, 06 Feb 2021 14:59:45 GMT

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

thanks,
Priyanka

Re: Qlik average time calculator

Anil_Babu_Samineni — Sat, 06 Feb 2021 15:56:06 GMT

Can you please share 10 rows and explain the output?

Re: Qlik average time calculator

wanass123 — Sat, 06 Feb 2021 17:33:47 GMT

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;