Sort order by time. Issues when exactly same time - Qlik Community

Report Inappropriate Content · ‎2014-11-13

Hi,

I'm trying to sort my transaction data by TimeStamp.

However, issues occur when there are more than one transaction at the very same point in time.

QV just ignores sorting these.

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:

08:00 100 USD

08:20 200 USD

08:30 300 USD

should be (after sorting):

08:00 200USD

08:20 400USD

08:30 600USD

Any ideas?

Kind REgards,

Olle

Report Inappropriate Content · ‎2014-11-13

Sample file attached.

Running balance should reflect prev running balance+next amount.

Kind Regards,

Olle