QlikView and Qlik Sense use the same underlying Qlik Indexing (QIX) engine, which means they also have the same value size limitations.
- April 2019 and earlier:
All numeric values are limited to 14 digits precision with the maximum value of (10^14)-1 = 99,999,999,999,999.
- June 2019 and later:
All numeric values are limited to 15 digits precision with the maximum value of (10^15)-1 = 999,999,999,999,999.
Numeric value larger than 14 integer digits the limit will be loaded as text, which also applies as for June 2019 and later. This means that they look like the source value but aggregations can not be performed as there is no underlying numerical value associated with the text.
However, if the number is loaded using the Evaluate() function, larger numbers can be loaded. They will, however, be rounded to the max number of significant digits.
Related articles:
Related documentation:
