topic Sort order by time. Issues when exactly same time in QlikView https://community.qlik.com/t5/QlikView/Sort-order-by-time-Issues-when-exactly-same-time/m-p/741065#M264694 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to sort my transaction data by TimeStamp.</P><P>However, issues occur when there are more than one transaction at the very same point in time.</P><P>QV just ignores sorting these.</P><P></P><P>Also, I was wondering, when this occurs is it possible to somehow sum these perticular transactions into single amounts for the specific times. For instance:</P><P></P><P><STRONG>08:00 </STRONG>100 USD</P><P><STRONG>08:00</STRONG> 100 USD</P><P><STRONG>08:20</STRONG> 200 USD</P><P><STRONG>08:20</STRONG> 200 USD</P><P><STRONG>08:30</STRONG> 300 USD</P><P><STRONG>08:30</STRONG> 300 USD</P><P></P><P>should be (after sorting):</P><P></P><P><STRONG>08:00</STRONG> 200USD</P><P><STRONG>08:20</STRONG> 400USD</P><P><STRONG>08:30</STRONG> 600USD</P><P></P><P></P><P></P><P></P><P></P><P>Any ideas?</P><P></P><P>Kind REgards,</P><P>Olle</P></BODY></HTML> Thu, 13 Nov 2014 15:36:43 GMT 2014-11-13T15:36:43Z Sort order by time. Issues when exactly same time https://community.qlik.com/t5/QlikView/Sort-order-by-time-Issues-when-exactly-same-time/m-p/741065#M264694 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to sort my transaction data by TimeStamp.</P><P>However, issues occur when there are more than one transaction at the very same point in time.</P><P>QV just ignores sorting these.</P><P></P><P>Also, I was wondering, when this occurs is it possible to somehow sum these perticular transactions into single amounts for the specific times. For instance:</P><P></P><P><STRONG>08:00 </STRONG>100 USD</P><P><STRONG>08:00</STRONG> 100 USD</P><P><STRONG>08:20</STRONG> 200 USD</P><P><STRONG>08:20</STRONG> 200 USD</P><P><STRONG>08:30</STRONG> 300 USD</P><P><STRONG>08:30</STRONG> 300 USD</P><P></P><P>should be (after sorting):</P><P></P><P><STRONG>08:00</STRONG> 200USD</P><P><STRONG>08:20</STRONG> 400USD</P><P><STRONG>08:30</STRONG> 600USD</P><P></P><P></P><P></P><P></P><P></P><P>Any ideas?</P><P></P><P>Kind REgards,</P><P>Olle</P></BODY></HTML> Thu, 13 Nov 2014 15:36:43 GMT https://community.qlik.com/t5/QlikView/Sort-order-by-time-Issues-when-exactly-same-time/m-p/741065#M264694 2014-11-13T15:36:43Z Re: Sort order by time. Issues when exactly same time https://community.qlik.com/t5/QlikView/Sort-order-by-time-Issues-when-exactly-same-time/m-p/741066#M264695 <HTML><HEAD></HEAD><BODY><P>Sample file attached.</P><P>Running balance should reflect prev running balance+next amount.</P><P></P><P>Kind Regards,</P><P>Olle </P></BODY></HTML> Thu, 13 Nov 2014 15:42:00 GMT https://community.qlik.com/t5/QlikView/Sort-order-by-time-Issues-when-exactly-same-time/m-p/741066#M264695 2014-11-13T15:42:00Z