Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

Convert Seconds into Hours

Hello experts I need help converting the code below from seconds to hours

(Sum({$<Month={"$(=Max(Month)-1)"}>}[Time To Assign Hours])

Thanks

ngumdo

3 Replies
Sue_Macaluso
Former Employee
Former Employee

@Pomna Are you using Qlik Sense or QlikView? I would like to move this into the correct product forum where it will get the right attention. 

Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!
Pomna
Creator III
Creator III
Author

Am using qlik sense

 

sunny_talwar
MVP
MVP

May be divide this by 3600 to convert seconds to hours

Sum({$<Month={"$(=Max(Month)-1)"}>}[Time To Assign Hours])/3600