Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Specialist

convert number to minute and seconde

Hello,

I have this set analysis in Qlik Sense

the result is 0,55

but i need that be 00:55 minutes

Thanks for help

1 Solution

Accepted Solutions
Specialist
Author

Hello,

The solution is :

Thansk for all

11 Replies
Partner

Hello ZIED,

use the function interval()

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

Specialist
Author

Hello Luc,

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

Regards

Partner

Here's an little example

Partner

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner

Hi Jonathan,

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

Specialist
Author

total response time / Total answred calls

Partner

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Specialist

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

Specialist
Author

Hello,

The solution is :