topic Re: Miscalculating Sum in QlikView

Miscalculating Sum

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

Hi All,

on my model i got a wrong result on Sum function.

as far as i know i don't have duplicated rows

after using Load Distinct on the relevant joined tables on the "DW", the problem seemed to be solved

was i doing the right thing? is that a good solution?

that's the "before" stage.

Sum needs to be equal to NetoWeigt

Date	Lot	NetoWeight	Sum
2017-05-22	G0136267	24300	72900

Thanks

Avner

PrashantSangle — Thu, 20 Jul 2017 10:02:20 GMT

Hi,

Looks like data become 3 times more than actual data.

check any wrong join which you did in your script.

Regards,

PrashantSangle — Thu, 20 Jul 2017 10:04:01 GMT

or try below expression

sum(aggr(Distinct sum(NetoWeight),Lot))

Regards

shiveshsingh — Thu, 20 Jul 2017 10:28:22 GMT

can you share the exact expression with data?

Anonymous — Thu, 20 Jul 2017 11:36:17 GMT

Tanks for all of your replies

Checked the script and the process again

and found out that even if select only few fields, i need to use Distinct.

otherwise i end up with multiple lines, even if i can't see them.