topic Re: Rounding issue in QlikView between different apps in App Development

Rounding issue in QlikView between different apps

bmac1 — Sun, 28 Apr 2024 06:36:49 GMT

Hi,

We are experiencing an issue where some numbers are not matching (off by 1) between apps due to a potential rounding error.

Both apps use the same set analysis/chart options but slightly different data marts. The value is returning the same at mart level but upon reload, is appearing differently on the UI.

if the value is 188.5

app1 might return 188

and app 2 might return 189

Re: Rounding issue in QlikView between different apps

Vegar — Sun, 28 Apr 2024 08:29:13 GMT

If you get different output it is probably because your 188.5 is different in the two applications.

188.5 can be any number x in interval 188.45<=x<188.55

In that interval all values <188.50 will be presented as 188, while any number >=188.50 will be presented as 189.

Try increasing the number of decimals in your application to see if this can be a valid explanation for the different outputs you see.

Re: Rounding issue in QlikView between different apps

barnabyd — Sun, 28 Apr 2024 21:31:02 GMT

G'day @bmac1,

I agree with @Vegar to increase your decimal places to discover where the differences are. To fix this type of problem, I would ask the client if they have a standard way of rounding their numbers. Even if they don't, the developer should be deliberate about where in the calculation the rounding should be done and always do it at the same place.

I hope this helps. Cheers, Barnaby.