Instantly share code, notes, and snippets.

Embed
What would you like to do?
Loading numbers in QlikView with more than 14 digits leads into scientific (exponential) notation. The 64-bit IEEE float can only show 14 digits.
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