Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
zhuravlevleonid
Contributor II
Contributor II

Reload returns different data

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.

1 Reply
Colin-Albert

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).