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