Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
olramirez
Contributor III
Contributor III

Comparative two columns

Hello, 

I have a problem when i want to comparate two numeric columns in a straight table. The first expression column is Amount, the second one is Paid2 (Paid2 is the aggregation of Paid by document). If this two columns are equals then Right else No Right. This looks very simple but i haven't been able to make it  😞   I have tried two options Val and Val2

Thanks for your help.

Olga

 

Labels (1)
1 Solution

Accepted Solutions
jwjackso
Specialist II
Specialist II

The numbers are different by fractional amounts.  Use the Round function like, Round(Paid2,.01).  See the QVW

View solution in original post

4 Replies
jwjackso
Specialist II
Specialist II

The numbers are different by fractional amounts.  Use the Round function like, Round(Paid2,.01).  See the QVW

View solution in original post

olramirez
Contributor III
Contributor III
Author

Thanks Jwjackso, this worked now.

🙂

 

Brett_Bleess
Support (Former)
Support (Former)

Just adding a Design Blog post on Rounding Errors to this one, just in case that may come into play for someone else.

https://community.qlik.com/t5/Qlik-Design-Blog/Rounding-Errors/ba-p/1468808

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.
olramirez
Contributor III
Contributor III
Author

Very interesting, thank you very much Brett