
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Remove Scientific Notation from Large Number
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?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the info. I am thinking of converting these large numeric values to surrogate key.
