topic Re: rounding issue in QlikView

rounding issue

davyqliks — Fri, 15 Nov 2024 23:52:32 GMT

Hi,

I have a simple expression taking an item value and multiplying by the stock in house:

0.2925 * 8000 = 2340 (correct)

0.0281 * 19700 = 553.57 ( 554.11 in QV ) odd rounding!

Can anyone explain why the 2nd example is not correct?

I have tried floor and ceil but no joy!

I am simply using

[UK Stock in House] * [UK EFP]

and have tried

Floor([UK Stock in House] * [UK EFP])

Ceil([UK Stock in House] * [UK EFP])

I know the difference is negligible but i really want this to be exact.

Thank you in advance if you can assist.

Daniel

Re: rounding issue

Kushal_Chawda — Thu, 01 Oct 2020 14:49:46 GMT

@davyqliks AFAIK, qlik does the rounding correctly. Values totally depend on what expression your using and underlying data. Probably you can provide the sample file to look at. Meanwhile try below

sum([UK Stock in House] )* sum([UK EFP])

Re: rounding issue

davyqliks — Fri, 16 Oct 2020 11:47:50 GMT

Thanks Kush 🙂