topic Re: avg time from timestamp in QlikView https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167767#M380020 <HTML><HEAD></HEAD><BODY><P>Thanks, thats working!</P></BODY></HTML> Mon, 18 Jul 2016 05:52:34 GMT 2016-07-18T05:52:34Z avg time from timestamp https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167763#M380016 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>im new in QlikView and I have a Question regarding the avg time from timestamps.</P><P></P><P>my field is a timestamp and the target is to calculate the average time - date is not important for me.</P><P></P><P>Result must be 04:11:00.</P><P></P><P>How can I do that?</P><P></P><P>Thanks for your help.</P><P></P><P>original field Format (Expression Default):</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/131444_pastedImage_5.png" style="max-height: 900px; max-width: 1200px;" /></P><P>number Format seeting: timestamp</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/131442_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 15 Jul 2016 09:58:21 GMT https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167763#M380016 2016-07-15T09:58:21Z Re: avg time from timestamp https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167764#M380017 <HTML><HEAD></HEAD><BODY><P>So are you trying to fix the Total row?</P></BODY></HTML> Fri, 15 Jul 2016 10:03:57 GMT https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167764#M380017 sunny_talwar 2016-07-15T10:03:57Z Re: avg time from timestamp https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167765#M380018 <HTML><HEAD></HEAD><BODY><P>mmhh sorry, what do you mean exactly? I think the solution must be anything like deleting date and having the time only...?</P></BODY></HTML> Fri, 15 Jul 2016 11:20:11 GMT https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167765#M380018 2016-07-15T11:20:11Z Re: avg time from timestamp https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167766#M380019 <HTML><HEAD></HEAD><BODY><P>To remove the date, you can use Frac</P><P><STRONG>Avg(Frac([Fahrt&nbsp; Beginn]))</STRONG></P></BODY></HTML> Fri, 15 Jul 2016 12:27:30 GMT https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167766#M380019 sunny_talwar 2016-07-15T12:27:30Z Re: avg time from timestamp https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167767#M380020 <HTML><HEAD></HEAD><BODY><P>Thanks, thats working!</P></BODY></HTML> Mon, 18 Jul 2016 05:52:34 GMT https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167767#M380020 2016-07-18T05:52:34Z Re: avg time from timestamp https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167768#M380021 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).</P><P>If not, please make clear what part of this topic you still need help with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Mon, 18 Jul 2016 07:24:51 GMT https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167768#M380021 oknotsen 2016-07-18T07:24:51Z Re: avg time from timestamp https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167769#M380022 <HTML><HEAD></HEAD><BODY><P>Done, thanks for your Help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 18 Jul 2016 07:37:29 GMT https://community.qlik.com/t5/QlikView/avg-time-from-timestamp/m-p/1167769#M380022 2016-07-18T07:37:29Z