Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Version upgrade issues from 12.1 to 12.3

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

1 Solution

Accepted Solutions
priyarane
Specialist
Specialist
Author

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'), '.')  

View solution in original post

5 Replies
NadiaB
Support
Support

Hi @priyarane 

Please review the following article:

Decimal Values In Qlik Sense And QlikView

Hope it helps.

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/
priyarane
Specialist
Specialist
Author

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
Specialist
Specialist
Author

Anyone has suggestion? 

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
priyarane
Specialist
Specialist
Author

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'), '.')  

View solution in original post