Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/QlikView_more_than_14_digits.qvs

Created September 13, 2013 13:09
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/6550467 to your computer and use it in GitHub Desktop.
Save ralfbecher/6550467 to your computer and use it in GitHub Desktop.
Download ZIP
Loading numbers in QlikView with more than 14 digits leads into scientific (exponential) notation. The 64-bit IEEE float can only show 14 digits.
Raw
QlikView_more_than_14_digits.qvs
LOAD Div(Field, 1e10) & left(repeat('0',10), 10 - len(text(Mod(Field, 1e10)))) & Mod(Field, 1e10) as MyNum
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment