topic Re: Comparative two columns in QlikView

Comparative two columns

olramirez — Sat, 16 Nov 2024 18:15:33 GMT

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

Re: Comparative two columns

jwjackso — Thu, 06 Aug 2020 22:33:36 GMT

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

Re: Comparative two columns

olramirez — Mon, 10 Aug 2020 15:26:58 GMT

Thanks Jwjackso, this worked now.

🙂

Re: Comparative two columns

Brett_Bleess — Thu, 20 Aug 2020 14:24:49 GMT

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

Re: Comparative two columns

olramirez — Thu, 20 Aug 2020 14:39:48 GMT

Very interesting, thank you very much Brett