Sum function returns 4 times the original value.

[msuvarna]

Hello everyone,

I am new to Qlik Sense and I am facing the following issue.

A field "Amount" when used in Chart as a dimension returns the correct value but when used as a measure (sum aggregation) is returning 4 times the original value. 

Could anyone please explain why this is happening? 

 There is no calculation involved in the backend (data load editor) or front end( chart expressions).

Source of data is Business Central but it is loaded through a QVD file.

[Or]

Presumably, there is some sort of duplication within your data structure. It's not possible to tell where it is from this chart, but the immediate suspects would be:

* Any field in this table that comes from a different logical table than the others

* Any JOIN or CONCATENATE operations done to the table containing Amount in the script (either before writing to QVD or after loading from QVD)

[BrunPierre]

This could possibly help

SUM(AGGR(SUM(Amount),EntryNo,Date))