topic How to Graph 2 timestamps together? in QlikView https://community.qlik.com/t5/QlikView/How-to-Graph-2-timestamps-together/m-p/902549#M313901 <HTML><HEAD></HEAD><BODY><P>I can successfully graph the number widgets received by hour using received timestamp below.&nbsp; I now want to (on the same graph) overlay ordered widgets using the ordered timestamp on the same graph.&nbsp; Each record has an ordered and received timestamp format MM/DD/YYYY hh:mm.&nbsp;&nbsp; Hour is calculated =hour(received timestamp)&nbsp; =hour(ordered timestamp).</P><P></P><P>Going a bit crazy with this one… please help/advise.&nbsp; Thanks!</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90812_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Thu, 25 Jun 2015 15:14:42 GMT richardouellett 2015-06-25T15:14:42Z How to Graph 2 timestamps together? https://community.qlik.com/t5/QlikView/How-to-Graph-2-timestamps-together/m-p/902549#M313901 <HTML><HEAD></HEAD><BODY><P>I can successfully graph the number widgets received by hour using received timestamp below.&nbsp; I now want to (on the same graph) overlay ordered widgets using the ordered timestamp on the same graph.&nbsp; Each record has an ordered and received timestamp format MM/DD/YYYY hh:mm.&nbsp;&nbsp; Hour is calculated =hour(received timestamp)&nbsp; =hour(ordered timestamp).</P><P></P><P>Going a bit crazy with this one… please help/advise.&nbsp; Thanks!</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90812_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Thu, 25 Jun 2015 15:14:42 GMT https://community.qlik.com/t5/QlikView/How-to-Graph-2-timestamps-together/m-p/902549#M313901 richardouellett 2015-06-25T15:14:42Z Re: How to Graph 2 timestamps together? https://community.qlik.com/t5/QlikView/How-to-Graph-2-timestamps-together/m-p/902550#M313902 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you could implement a canonical date calendar like decribed here:</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 25 Jun 2015 15:44:28 GMT https://community.qlik.com/t5/QlikView/How-to-Graph-2-timestamps-together/m-p/902550#M313902 MarcoWedel 2015-06-25T15:44:28Z Re: How to Graph 2 timestamps together? https://community.qlik.com/t5/QlikView/How-to-Graph-2-timestamps-together/m-p/902551#M313903 <HTML><HEAD></HEAD><BODY><P>Marco, Thank you for providing this information.</P></BODY></HTML> Fri, 26 Jun 2015 09:27:58 GMT https://community.qlik.com/t5/QlikView/How-to-Graph-2-timestamps-together/m-p/902551#M313903 richardouellett 2015-06-26T09:27:58Z