convert number to minute and seconde

[zied_ahmed1]

Hello,

I have this set analysis in Qlik Sense

sum({<$(vSetPeriodPres)>}CALLSANSWEREDDELAY)/ sum({<$(vSetPeriodPres)>}CALLSANSWERED)

the result is 0,55

but i need that be 00:55 minutes

Thanks for help

[lucpechali]

Hello ZIED,

use the function interval()

interval(sum({<$(vSetPeriodPres)>}CALLSANSWEREDDELAY)/ sum({<$(vSetPeriodPres)>}CALLSANSWERED)) as xxx

And use interval number format in your application

You can also format the output format using interval(sum(x),'hh:mm:ss')

Hope it helps

[zied_ahmed1]

Hello Luc,

Thanks for help,but when i use the function i have the same result 0,55..

Regards

[lucpechali]

Here's an little example

[jonathandienst]

I am confused. Your expression is a ratio of times. How would that make sense expressed as a time/interval? It seems to me that it should be expressed as a decimal (0.55) or a percent (55%).

[lucpechali]

Hi Jonathan,

I was supposing his fields were time format and he'd like to have a total for the delays

[zied_ahmed1]

total response time / Total answred calls

[jonathandienst]

How about

=Interval(Sum({<$(vSetPeriodPres)>} CALLSANSWEREDDELAY) / Sum({<$(vSetPeriodPres)>} CALLSANSWERED) / 24, 'hh:mm')

[luismadriz]

Hi Zied,

It all depends on the unit of CALLSANSWEREDDELAY. If it's hours then you use this:

=Interval(Sum({<$(vSetPeriodPres)>} CALLSANSWEREDDELAY) / Sum({<$(vSetPeriodPres)>} CALLSANSWERED) / 24, 'hh:mm:ss')

If CALLSANSWEREDDELAY is in minutes then you use this:

=Interval(Sum({<$(vSetPeriodPres)>} CALLSANSWEREDDELAY) / Sum({<$(vSetPeriodPres)>} CALLSANSWERED) / 24 / 60, 'hh:mm:ss')

I hope this helps,

Luis

[zied_ahmed1 · Accepted solution]

Hello,

The solution is :

=interval(timestamp#(round(sum({<$(vSetPeriodPres)>}CALLSANSWEREDDELAY)/ sum({<$(vSetPeriodPres)>}CALLSANSWERED)),'m'), 'hh:mm')

Thansk for all