Skip to main content
Announcements
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AnnaRodriguez
Partner - Contributor II
Partner - Contributor II

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?

 

Labels (2)
1 Solution

Accepted Solutions
Digvijay_Singh

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-b...

 

View solution in original post

2 Replies
Digvijay_Singh

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-b...

 

AnnaRodriguez
Partner - Contributor II
Partner - Contributor II
Author

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