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