Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

Probably because of rounding errors: Rounding Errors.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Probably because of rounding errors: Rounding Errors.


talk is cheap, supply exceeds demand