Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

FirstSortedValue, find last value before (or equal to) 08:00

Hi,

need to find the last value before (or equal to) 08:00 but the below expression does not work properly, any ideas?

Pls find attached example files.

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

Rgds,

Olle

10 Replies
Digvijay_Singh

I think Settlement Time is in timestamp format, it might not work in set analysis when we compare it with value having time format(8:00..). that is the reason I added new field converted into time format in script. Also in source data there is 'dot' after seconds, so I think we need to use format 'hh:mm:ss.ffffff' with time# to interpret correctly though haven't checked yet if that makes much difference.