Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

What is the largest numeric value that can be loaded in Qlik Sense and QlikView?

ToniKautto
Employee
Employee

What is the largest numeric value that can be loaded in Qlik Sense and QlikView?

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:

Labels (1)
Version history
Last update:
‎2021-07-07 10:22 PM
Updated by:
Contributors