Reload returns different data

zhuravlevleonid — Wed, 25 Nov 2020 16:16:04 GMT

Dear community,

I faced such a problem: after a reload of a model numbers in my table are changing (without changing a script or initial data). Each reload provides different numbers, but deviation is in range +- 0.05 (seems like something happens with round()).

I am loading data from 2 tables on SQL server and Qlik is joining them on 1 field:

SQL

select Key, debit, credit, ...., .... from X;

SQL

select Key, mapping and configuration fields, ... from Y;

Debit and credit are in decimal(n, 2) format. Number of records is about 10 mil.

What could be the problem? I am really going mad how predefined algorithm on a same data provides different result.

Re: Reload returns different data

Colin-Albert — Thu, 14 Jun 2018 15:14:02 GMT

This post may help understand the issue you are seeing Rounding Errors‌

Perhaps the answer may be to store the values as integer cents/pence rather than as a decimal(n,2).

topic Re: Reload returns different data in QlikView

Reload returns different data

Re: Reload returns different data