Number Precision

[ktucker8]

Hi,

Have some number data in a load that is over 14 characters long with QlikView.  Looking to increase the number precision setting from 14 to 16 or another approach to allow all numbers to be displayed.  Currently, it cuts off at the 14th digit.  Has anyone encountered this and found solution?

Thanks!

[sunny_talwar]

May be this can be of help:

Loading numbers in QlikView with more than 14 digits leads into scientific (exponential) notation. T...

[sunny_talwar · Accepted solution]

Another one:

Evaluate() Function

[swuehl]

Or maybe use Text(FIELD) to keep all digits for displaying the number.

Either way, the internal number representation is limited to this precision so you won't make any calculations more precise.

[ktucker8]

Thank you...This confirmed what I've found so far.  I can display the number but calculations will only go 14 digits.  Thanks again for the help!

[ktucker8]

Thank you...this confirms what I'm seeing that the calculations won't adjust.

Thanks for the help!

[oknotsen]

If your question is now answered, please flag the Correct Answer (and possible Helpful Answers).

If not, please make clear with what part of this topic you still need help with .