Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III
‎2017-07-18 06:52 AM

seconds into Minutes

Hello Guys,

I have an output in seconds. how to convert it into minutes.

Thanks

4,486 Views
0 Likes
25 Replies
master_student
Creator III
Creator III
‎2017-07-19 07:01 AM
Author

In response to sunny_talwar

no i am just trying to explain

761 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2017-07-19 07:01 AM

In response to master_student

Even, Question not clear. I am sorry

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
761 Views
0 Likes
master_student
Creator III
Creator III
‎2017-07-19 07:02 AM
Author

In response to PrashantSangle

the result will be with comma

761 Views
0 Likes
sunny_talwar
MVP
MVP
‎2017-07-19 07:03 AM

In response to master_student

So convert 2400 seconds to 40 mins? Is this what you want to do?

Interval(Interval#(SecondsField, 's'), 'm') as Minutes

3,653 Views
PrashantSangle
MVP
MVP
‎2017-07-19 07:21 AM

In response to master_student

Can you explain little bit more

For example if your input is 4200 sec then what is your expected output???

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
761 Views
0 Likes
Uri
Creator
Creator
‎2020-07-31 11:41 AM

This helped me:

=Interval(Interval#([Voice(MIN)], 's'), 'hh:mm:ss')

675 Views