topic How to calculate total job/ Total Hours in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341434#M839183 <HTML><HEAD></HEAD><BODY><P>Hi all </P><P></P><P> i have field like total Job and Total hours related to employee i need to to show <STRONG>Total Job / Total Hours</STRONG> and <STRONG>Total Hours / Total Job</STRONG> but it show wrong data </P><P></P><P>how i want to calculate that, please find attachment for sample Qvw&nbsp;&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT vengadeshpalani 2020-11-25T16:16:04Z How to calculate total job/ Total Hours https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341434#M839183 <HTML><HEAD></HEAD><BODY><P>Hi all </P><P></P><P> i have field like total Job and Total hours related to employee i need to to show <STRONG>Total Job / Total Hours</STRONG> and <STRONG>Total Hours / Total Job</STRONG> but it show wrong data </P><P></P><P>how i want to calculate that, please find attachment for sample Qvw&nbsp;&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341434#M839183 vengadeshpalani 2020-11-25T16:16:04Z Re: How to calculate total job/ Total Hours https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341435#M839184 <HTML><HEAD></HEAD><BODY><P>What is wrong output?? What is the expected output</P></BODY></HTML> Sun, 14 May 2017 13:59:26 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341435#M839184 sunny_talwar 2017-05-14T13:59:26Z Re: How to calculate total job/ Total Hours https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341436#M839185 <HTML><HEAD></HEAD><BODY><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163279_1.png" style="height: 126px; width: 620px;" /></P></BODY></HTML> Sun, 14 May 2017 14:16:10 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341436#M839185 vengadeshpalani 2017-05-14T14:16:10Z Re: How to calculate total job/ Total Hours https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341437#M839186 <HTML><HEAD></HEAD><BODY><P>Your time is in seconds, you need to divide by 24... try this</P><P></P><P><STRONG>Count(JobID)/sum(TotalSec)/24</STRONG></P></BODY></HTML> Sun, 14 May 2017 14:32:11 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341437#M839186 sunny_talwar 2017-05-14T14:32:11Z Re: How to calculate total job/ Total Hours https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341438#M839187 <HTML><HEAD></HEAD><BODY><P>what is the logic, can u explain based on day, hour, minutes, seconds</P></BODY></HTML> Sun, 14 May 2017 14:45:25 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341438#M839187 vengadeshpalani 2017-05-14T14:45:25Z Re: How to calculate total job/ Total Hours https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341439#M839188 <HTML><HEAD></HEAD><BODY><P>No logic, just converting your seconds into a day</P></BODY></HTML> Sun, 14 May 2017 14:48:56 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-total-job-Total-Hours/m-p/1341439#M839188 sunny_talwar 2017-05-14T14:48:56Z