Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vengadeshpalani
Creator
Creator

How to calculate total job/ Total Hours

Hi all

i have field like total Job and Total hours related to employee i need to to show Total Job / Total Hours and Total Hours / Total Job but it show wrong data

how i want to calculate that, please find attachment for sample Qvw  

1 Solution

Accepted Solutions
sunny_talwar

Your time is in seconds, you need to divide by 24... try this

Count(JobID)/sum(TotalSec)/24

View solution in original post

5 Replies
sunny_talwar

What is wrong output?? What is the expected output

vengadeshpalani
Creator
Creator
Author

1.png

sunny_talwar

Your time is in seconds, you need to divide by 24... try this

Count(JobID)/sum(TotalSec)/24

vengadeshpalani
Creator
Creator
Author

what is the logic, can u explain based on day, hour, minutes, seconds

sunny_talwar

No logic, just converting your seconds into a day