topic Remove Scientific Notation from Large Number in QlikView

Remove Scientific Notation from Large Number

AnnaRodriguez — Fri, 08 Sep 2023 16:10:56 GMT

My numeric keys have values with up to 20 digits. When storing data into QVD, i see scientific notation numbers stored instead numeric. Is there a way to stop Qlikview from using scientific notation for numbers larger than 15 digits?

Re: Remove Scientific Notation from Large Number

Digvijay_Singh — Fri, 08 Sep 2023 17:14:23 GMT

I actually never came across this situation but read many a times that Qlik cannot handle more than 15 digits numeric keys, see this below article for the work around using evaluate but not sure if it would work for you, and converting to text might be a solution but it could slow down the server if you got high volume of data.

https://community.qlik.com/t5/Official-Support-Articles/What-is-the-largest-numeric-value-that-can-be-loaded-in-Qlik/ta-p/1744936

Re: Remove Scientific Notation from Large Number

AnnaRodriguez — Sat, 09 Sep 2023 01:44:19 GMT

Thanks for the info. I am thinking of converting these large numeric values to surrogate key.