topic Re: convert number to minute and seconde in Management & Governance

convert number to minute and seconde

zied_ahmed1 — Mon, 11 Dec 2017 12:36:49 GMT

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

Re: convert number to minute and seconde

lucpechali — Mon, 11 Dec 2017 12:44:04 GMT

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

Re: convert number to minute and seconde

zied_ahmed1 — Mon, 11 Dec 2017 12:49:40 GMT

Hello Luc,

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

Regards

Re: convert number to minute and seconde

lucpechali — Mon, 11 Dec 2017 13:11:11 GMT

Here's an little example

Re: convert number to minute and seconde

jonathandienst — Mon, 11 Dec 2017 13:16:21 GMT

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%).

Re: convert number to minute and seconde

lucpechali — Mon, 11 Dec 2017 13:20:50 GMT

Hi Jonathan,

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

Re: convert number to minute and seconde

zied_ahmed1 — Mon, 11 Dec 2017 14:02:49 GMT

total response time / Total answred calls

Re: convert number to minute and seconde

jonathandienst — Tue, 12 Dec 2017 04:38:12 GMT

How about

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

Re: convert number to minute and seconde

luismadriz — Tue, 12 Dec 2017 05:21:01 GMT

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

Re: convert number to minute and seconde

zied_ahmed1 — Tue, 12 Dec 2017 08:35:00 GMT

Hello,

The solution is :

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

Thansk for all

Re: convert number to minute and seconde

zied_ahmed1 — Tue, 12 Dec 2017 08:35:36 GMT

Hello,

The solution is :

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

Thanks for all

Re: convert number to minute and seconde

luismadriz — Tue, 12 Dec 2017 23:14:41 GMT

Good it helped,

Luis

PS. When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others