Version upgrade issues from 12.1 to 12.3

[priyarane]

Hello Community,

We recently upgraded to 12.3 from 12.1 version and we found one issue related to Decimal round off. 

Ex value:

12.1 : 10000.6199989319

The above same value is coming in 12.3 as 10000.6200000000

Correct value is getting in 12.1 not in 12.3 so can someone please suggest how to get it sorted out this issue.

_Priya

[NadiaB]

Hi @priyarane 

Please review the following article:

Decimal Values In Qlik Sense And QlikView

Hope it helps.

[priyarane]

Hi Nadia,

12.1 also uses the same engine but we got the issue when we upgrade to 12.3. still we have 2 environments and shows different types of decimals for the same value

[priyarane]

Anyone has suggestion? 

[Brett_Bleess]

Found another article reference for you:

Rounding issues

Let us know if that helps or not.  Also, if you are not running 12.30.20300 SR3, I would also recommend trying that release as well to be sure you still see the issue there.  If so, I would suggest you go ahead and open a support case with us and include a sample app in the case with steps on how we can see the issue, we should be able to submit to R&D for further review at that point if things behave the same way for us.

Regards,
Brett

[priyarane · Accepted solution]

no fix from QLIK as behavior is like that only for 12.3.

So we have fixed while loading from DB.

rtrim(to_char(YourColumn, 'FM999999999999990.99'), '.')