Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.
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
Go to Solution.
Probably because of rounding errors: Rounding Errors.
View solution in original post