Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/QlikView_get_and_format_microseconds.qvs

Last active August 29, 2015 14:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ralfbecher/9ef5b6f59fc9afa37bda to your computer and use it in GitHub Desktop.
Save ralfbecher/9ef5b6f59fc9afa37bda to your computer and use it in GitHub Desktop.
Download ZIP
QlikView get and format microseconds
Raw
QlikView_get_and_format_microseconds.qvs
//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