Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
greend21
Contributor II

Show 18 digit number without scientific notation?

I have some long policy numbers I need to show, but it seems like Qlik Sense is putting anything over 16 digits in scientific notation. This is not helpful for policy numbers. I tried loading it as text but it has not worked.

4 Replies
JustinDallas
Valued Contributor II

Re: Show 18 digit number without scientific notation?

Are you talking about the format in the UI or in the script? 

MVP & Luminary
MVP & Luminary

Re: Show 18 digit number without scientific notation?

Can you post your script snippet where you are loading as text() and your UI where you are seeing the exponential notation?  I can't recreate the problem.

 

-Rob

greend21
Contributor II

Re: Show 18 digit number without scientific notation?

I tried different formatting both in the script and UI. I think the issue was I was pulling from excel and although excel didn't show the information in the scientific notation format it may have been passing it. Once I saved the .xlsx as a .csv I was able to get it to work.
greend21
Contributor II

Re: Show 18 digit number without scientific notation?

It seems like this was an issue with the data coming from excel. Once I changed the filed to .csv I was able to load the information in and correctly display it.