idea From now on, please track this idea from the Ideation por... in Suggest an Idea

Numeric fields on Qlik Sense must accept more than 14 digits

simonaubert — Wed, 25 Nov 2020 08:50:26 GMT

Hello all,

Here is a real big issue I face on a new project with an Oracle Database : all the id are integer (cool)... but 15-16 digits integers. Oracle allows that kind of stuff (actually, if I understan https://docs.oracle.com/cd/E18283_01/server.112/e17110/limits001.htm it can goes to 38 digits !!).

Si, what's the heck ?

Qlik Sense only allows 14 digits numeric fields. This is related to IEE754 (https://ieeexplore.ieee.org/xpl/mostRecentIssue.jsp?punumber=4610933 )

Some posts on the issue, to see it's quite a big deal :
https://community.qlik.com/t5/New-to-Qlik-Sense/Problem-with-big-numbers-more-than-14-digits/m-p/36940
https://community.qlik.com/t5/QlikView-App-Development/Problem-reading-numbers-over-14-digits/td-p/175593

https://community.qlik.com/t5/New-to-QlikView/calculation-issue-for-14-digits/td-p/1197424

Of course, there are turnaround with the Evaluate function or the casting in text (to_char in sql may do the job) but this is really, really, really inefficient in term of performance when you have 500 millions of line !!

Best regards,

Simon

Re: Numeric fields on Qlik Sense must accept more than 14 digits - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Thu, 12 Nov 2020 14:07:54 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,
Patric

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:50:37 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Numeric fields on Qlik Sense must accept more than 14 digits - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:50:39 GMT