topic Re: Join on rounded value not working in QlikView

Join on rounded value not working

pepe2209 — Tue, 07 Oct 2014 12:45:00 GMT

Hello,

I have a problem of which i think it is a bug.

Our database has values like this: 56,99999999994 or 23,99999999997

Now i need to join data based upon the rounded value (57 or 24) of this field.

This does not work for two cases:

if the number is xx0,9999999999 -> rounded to xx1

or if the number is xx5,9999999999 -> rounded to xx6

For this the join does not match and therefore joined fields are empty.

for all other rounded values the join does match. is this a bug or am i overlooking something??

your help would be much appreciated.

Anonymous — Tue, 07 Oct 2014 12:48:03 GMT

Can you upload a small example of your app?

ashfaq_haseeb — Tue, 07 Oct 2014 12:48:21 GMT

Hi,

Check this

Regards

ASHFAQ

pepe2209 — Tue, 07 Oct 2014 12:55:57 GMT

Ok thanks!

I guess i understand the rounding 'error' that occurs.

I fixed my problem by changing the rounded value into a text value only for the join statement.