topic Re: Time Average in QlikView https://community.qlik.com/t5/QlikView/Time-Average/m-p/933207#M322409 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><SPAN style="font-size: 13.3333px;">Just so I don't look like an idiot, I think I should fix this <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P><SPAN style="text-decoration: line-through;"><STRONG>Avg(Interval(OutTime-InTime,'hh:mm'))</STRONG></SPAN></P><P><STRONG style="font-size: 13.3333px;"><STRONG>Interval(Avg(OutTime-InTime),'hh:mm')</STRONG></STRONG></P></BODY></HTML> Wed, 18 Nov 2015 13:10:20 GMT sunny_talwar 2015-11-18T13:10:20Z Time Average https://community.qlik.com/t5/QlikView/Time-Average/m-p/933206#M322408 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Please find the attached QVW.</P><P></P><P>Employee 'hr head' has net duration of 10:20 and 'hr payrolladmin' has 05:35.</P><P></P><P>If both the employees are selected it should show the average of net duration. But curently it shows 'No Data'</P><P></P><P>Regards,</P><P>Keerthi KS</P></BODY></HTML> Wed, 18 Nov 2015 13:06:36 GMT https://community.qlik.com/t5/QlikView/Time-Average/m-p/933206#M322408 2015-11-18T13:06:36Z Re: Time Average https://community.qlik.com/t5/QlikView/Time-Average/m-p/933207#M322409 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><SPAN style="font-size: 13.3333px;">Just so I don't look like an idiot, I think I should fix this <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P><SPAN style="text-decoration: line-through;"><STRONG>Avg(Interval(OutTime-InTime,'hh:mm'))</STRONG></SPAN></P><P><STRONG style="font-size: 13.3333px;"><STRONG>Interval(Avg(OutTime-InTime),'hh:mm')</STRONG></STRONG></P></BODY></HTML> Wed, 18 Nov 2015 13:10:20 GMT https://community.qlik.com/t5/QlikView/Time-Average/m-p/933207#M322409 sunny_talwar 2015-11-18T13:10:20Z Re: Time Average https://community.qlik.com/t5/QlikView/Time-Average/m-p/933208#M322410 <HTML><HEAD></HEAD><BODY><P>Always use aggregation functions in your expressions:</P><P></P><P>=Interval(Avg(OutTime-InTime),'hh:mm')</P><P></P><P>Edit:</P><P>You also need to apply aggregation functions to the bar offset and other expressions used. I am unsure how you want to display the reference lines etc. in case of multiple employees selected.</P></BODY></HTML> Wed, 18 Nov 2015 13:11:29 GMT https://community.qlik.com/t5/QlikView/Time-Average/m-p/933208#M322410 swuehl 2015-11-18T13:11:29Z Re: Time Average https://community.qlik.com/t5/QlikView/Time-Average/m-p/933209#M322411 <HTML><HEAD></HEAD><BODY><P>Damn man, you always manage to find my mistake <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 18 Nov 2015 13:13:01 GMT https://community.qlik.com/t5/QlikView/Time-Average/m-p/933209#M322411 sunny_talwar 2015-11-18T13:13:01Z Re: Time Average https://community.qlik.com/t5/QlikView/Time-Average/m-p/933210#M322412 <HTML><HEAD></HEAD><BODY><P>Maybe using an average bar offset?</P></BODY></HTML> Wed, 18 Nov 2015 13:15:01 GMT https://community.qlik.com/t5/QlikView/Time-Average/m-p/933210#M322412 swuehl 2015-11-18T13:15:01Z Re: Time Average https://community.qlik.com/t5/QlikView/Time-Average/m-p/933211#M322413 <HTML><HEAD></HEAD><BODY><P>Reference lines is only for Core working hours. It should not be changed as per the requirements.</P></BODY></HTML> Thu, 19 Nov 2015 04:32:22 GMT https://community.qlik.com/t5/QlikView/Time-Average/m-p/933211#M322413 2015-11-19T04:32:22Z Re: Time Average https://community.qlik.com/t5/QlikView/Time-Average/m-p/933212#M322414 <HTML><HEAD></HEAD><BODY><P>Ha Ha <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Thanks Sunny <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 19 Nov 2015 04:34:11 GMT https://community.qlik.com/t5/QlikView/Time-Average/m-p/933212#M322414 2015-11-19T04:34:11Z