Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

Importing from SQLServer I divide amount with 1000000. This produces a different result than when I do the same operation in SQLServer. Why is that?

Importing from SQLServer I divide amount with 1000000. This produces a different result than when I do the same operation in SQLServer. Why is that?

If I import amount as they are everything is OK.

I present the result in QLIK Sense desktop  formatting as Number  and Simple.

The result in   SQL is  13261,0996    and in QLIK Sense     13 260,70

When I divide using expressions the result is correct so I should probably do it like this instead.

Best Regards,   Leif

1 Solution

Accepted Solutions

Re: Importing from SQLServer I divide amount with 1000000. This produces a different result than when I do the same operation in SQLServer. Why is that?

Probably because of rounding errors: Rounding Errors.


talk is cheap, supply exceeds demand
1 Reply

Re: Importing from SQLServer I divide amount with 1000000. This produces a different result than when I do the same operation in SQLServer. Why is that?

Probably because of rounding errors: Rounding Errors.


talk is cheap, supply exceeds demand
Community Browser