Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

What is wrong output?? What is the expected output

Creator
Creator

1.png

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

Count(JobID)/sum(TotalSec)/24

View solution in original post

Creator
Creator

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

No logic, just converting your seconds into a day