topic Re: Number Precision in QlikView

Number Precision

ktucker8 — Wed, 20 Apr 2016 19:20:57 GMT

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!

Re: Number Precision

sunny_talwar — Wed, 20 Apr 2016 20:09:13 GMT

May be this can be of help:

Loading numbers in QlikView with more than 14 digits leads into scientific (exponential) notation. The 64-bit IEEE float…

Re: Number Precision

sunny_talwar — Wed, 20 Apr 2016 20:09:42 GMT

Another one:

Evaluate() Function

Re: Number Precision

swuehl — Wed, 20 Apr 2016 20:16:24 GMT

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.

Re: Number Precision

ktucker8 — Thu, 21 Apr 2016 14:45:33 GMT

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!

Re: Number Precision

ktucker8 — Thu, 21 Apr 2016 14:46:12 GMT

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

Thanks for the help!

Re: Number Precision

oknotsen — Thu, 21 Apr 2016 14:54:44 GMT

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 .