topic First sorted value Time in QlikView

First sorted value Time

Thu, 17 Sep 2015 14:57:42 GMT

The below conversion results in the below time format: 07:00:04:100000

Time(round([Settlement timestamp], 1/8640000 ), 'hh:mm:ss:ffffff') as SettlementTime

However when I try to find the last corresponding balance before 08:00 (as per below) Im getting null values.

The same methodology works perfect when my time format is hh:mm:ss

FirstSortedValue({<SettlementTime={'<08:00:00:000000'}>} RunningBalance,-SettlementTime)

any ideas?

sunny_talwar — Thu, 17 Sep 2015 15:01:06 GMT

May be you need this:

FirstSortedValue({<SettlementTime={"$(='<' & Time('08:00:00:000000', 'hh:mm:ss:ffffff'))"}>} RunningBalance,-SettlementTime)

sunny_talwar — Thu, 17 Sep 2015 15:01:52 GMT

What format is is SettlementTime? Just make sure it is in hh:mm:ss:ffffff