topic Re: Getting interval duration in QlikView

Getting interval duration

martinqlik — Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

I need to get the execution time btw several actions.

For example, the tasks starts as 'Aberto', then it goes to 'Aguarda Informacao PATS', and etc, until get into 'Recebido' which is the last status.

I attached a qvw with these informations, including the field execution time that needs to be calculated.

Does anybody knows how to make this?

Thank you,

ahaahaaha — Wed, 03 May 2017 14:54:15 GMT

Hi Martin,

If I correctly understood you, as an variant in the attached file.

Regards,

Andrey

antoniotiman — Wed, 03 May 2017 15:45:54 GMT

Hi Martin,

maybe

Interval(Max(TOTAL <ATIVIDADE> DATA_ALTERACAO)-Min(TOTAL <ATIVIDADE> DATA_ALTERACAO),'hh:mm:ss')

Regards,

Antonio