Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'), '.')
Hi @priyarane
Please review the following article:
Decimal Values In Qlik Sense And QlikView
Hope it helps.
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
Anyone has suggestion?
Found another article reference for you:
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
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'), '.')