Solved: round off - Page 2 - Qlik Community

soniasweety · ‎2017-08-04

Hi all,

I am still facing the issue with the format.

I have written this in script

num(floor( duration)/3600,'##.##') as mytime,

duration in seconds.

but I need to show with two decimal

am getting output like below I need 1274.62 like that

1274.621667

1012.946389

soniasweety · ‎2017-08-04

syntax error it showing

soniasweety · ‎2017-08-04

still same no luck

sunny_talwar · ‎2017-08-04

My bad, try this

Interval(Floor(Now() - cmDate, 1/24), 'hh') as lefttime

Anil_Babu_Samineni · ‎2017-08-04

I am getting 854? Not correct

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

PrashantSangle · ‎2017-08-04

Hi,

Simple num#() will do the trick.

num#(Interval(Now()-cmDate,'hh'),'#')

Regards,

Prashant

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 🙂

soniasweety · ‎2017-08-04

no luck sunny still same

sunny_talwar · ‎2017-08-04

Can you share screenshots?

Kushal_Chawda · ‎2017-08-04

try this

round(mod(floor((Now()-cmDate)*24*60*60),86400) /3600,0.01)

soniasweety · ‎2017-08-04

its not working

1274.62 instead of this giving 1.02 like that all values

Kushal_Chawda · ‎2017-08-04

Can you give me one example? above logic will calculate total hours only between two dates

round off

Related Topics