Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
QlikView get and format microseconds
//Formula to optain microseconds from TimeField:
LOAD ((frac(TimeField) * 86400000) - floor(frac(TimeField) * 86400000)) * 1000 as Micro
FROM ...;
//Use this formula for formatting:
LOAD Timestamp(TimeField - (Micro/86400000000)) & Num(floor(Micro), '000') as TimeStamp
FROM ...;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.