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