
Master
2017-07-13
08:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
round seconds
Hi all ,
I have one column like duration
that are in seconds like
30210.00
916372.00
56483.00
like above I don't want to see .00 I want output like
hh.mm : =30210 is to be shown like this 8.39
am using in my script already like this Num([Duration],'#.#0') as "Task Duration", I need along with this format
Thanks
Sony
1,049 Views
1 Solution
Accepted Solutions

MVP
2017-07-13
08:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
num(floor(dateField)/3600,'##.##')
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 🙂
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 🙂
4 Replies

MVP
2017-07-13
08:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try like
floor(fieldName)/3600
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 🙂
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 🙂

Master
2017-07-13
08:38 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks Prashanth,
but I need the format also like what I mentioned above.
how can include this into above?
is this correct?
floor( Num([Duration]/3600,'#.#0')) as "Task Duration"
987 Views

MVP
2017-07-13
08:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
num(floor(dateField)/3600,'##.##')
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 🙂
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 🙂

Master
2017-07-13
08:45 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks prashanth its working as expected
987 Views
