Qlik Community

Qlik Sense Integration, Extensions, & APIs

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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
MVP & Luminary
MVP & Luminary

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

View solution in original post

1 Reply
MVP & Luminary
MVP & Luminary

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

View solution in original post