Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
AnnaRodriguez
Partner - Contributor III
Partner - Contributor III

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 III
Partner - Contributor III
Author

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