Rounding issues in Qlik Sense

Tue, 18 Apr 2017 10:01:59 GMT

Hello All,

I load data from a table having a column with datatype decimal(17,2); it's dedicated to financial amounts.

When Qlik sense displays a (large!) sum on this column, the result differs slightly from the result I get with a SQL-query. More surprisingly, Qlik sense gives different results in the sum of a table and in a text field with the formula Sum([MU Amount]):

The correct result is:

The difference is only some units on a large amount, but it's unacceptable with financial data.

As a workaround, I use a new column where these values are multiplied by 100 and casted to integer, I perform a sum on it and I divide the result by 100 ( Sum([MU Amount x 100])/100 ). And I don't use the total in tables anymore.

Does anybody encounters the same type of issue ?

Regards,

Gauthier

Re: Rounding issues in Qlik Sense

michal_durica — Mon, 27 Nov 2017 16:01:46 GMT

Hi Gauthier,

we have the same issue with small difference in decimals

I tried to replicate your approach but it doesn't work.

The data is stored in format numeric(19,4).

Don't you have any other tips how to avoid it?

Thanks

Michal

topic Rounding issues in Qlik Sense in QlikView

Rounding issues in Qlik Sense

Re: Rounding issues in Qlik Sense