topic Re: Sum function false result in QlikView

Sum function false result

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

Hello everybody,

when I checked my QV calculation, one line turned out to be wrong. When I calculate the sum of "StckPlan" in Excel the result is 9480 - according to QV it is 2370.

Basically it is a very simple function (Sum(MPS_productionorder.amount)).

Has anyone ever had a similar problem and knows why it could be?

Thanks,

Dominic

Re: Sum function false result

sunny_talwar — Wed, 08 May 2019 11:02:22 GMT

Are the fields coming from different tables in the backend of the application? It seems that there is a many to many implicit join between fields from different tables which might be duplicating the sum when those fields are added, but not when you use the fields from a single table in the below table.

Re: Sum function false result

dominicanlauf — Wed, 08 May 2019 11:25:43 GMT

The application consists of 40 tables, which come from two production planning systems.

The upper pivot table consists of 7 tables. At this point the informations are complete.

The lower table sums up the columns, ignoring some of the values.

I can not change anything about the structure of the data, which I get from the IT department. It should be possible to sum up the values anyway or not?

Dominic

Re: Sum function false result

sunny_talwar — Wed, 08 May 2019 11:29:35 GMT

It definitely is, all you need to do is to do something like this

Sum(Aggr(Sum(StckPlan), Mat, Anlage, ok, gel))

Re: Sum function false result

dominicanlauf — Wed, 08 May 2019 11:36:57 GMT

Great, it works!

Thank you!