Skip to content

Instantly share code, notes, and snippets.

@theredpea

theredpea/qlik_dual_number_limit.qvs

Created December 16, 2019 18:56
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 theredpea/f7d004f148d186cc878a3def1f6f6fc0 to your computer and use it in GitHub Desktop.
Save theredpea/f7d004f148d186cc878a3def1f6f6fc0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
qlik_dual_number_limit.qvs
// https://community.qlik.com/t5/QlikView-App-Development/number-of-17-digits/m-p/511285
/*
Henric_Cronström
Employee
Henric_Cronström
Employee 2013-09-12 01:44 PM
Re: number of 17 digits
As Gysbert says, such a large number cannot be displayed as an integer. The 64-bit IEEE float can only show 14 digits. Instead, you should try
*/
LOAD DUAL(t,n) INLINE [
t, n
h1, 100000000000000000000000000000000000000000000000000000000000001
h2, 1000000000000000000000000000001
h3, 10000000000000000000001
h4, 1000000000000001
h5, 100000000000001
QLIK_WILL_STOP_DISTINGUISHING_INTEGERS_LARGER_THAN_H6_(14 DIGITS), -1
h6, 10000000000001
h6+9, 99999999999999
h6-9, -99999999999999
h7, 1000000000001
h8, 10000000001
h_, 2
];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment