Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dominicanlauf
Contributor III
Contributor III

Sum function false result

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?

 

SummeFalsch.PNG

Thanks,

Dominic

1 Solution

Accepted Solutions
sunny_talwar

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

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

 

View solution in original post

4 Replies
sunny_talwar

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.

dominicanlauf
Contributor III
Contributor III
Author

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

sunny_talwar

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

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

 

dominicanlauf
Contributor III
Contributor III
Author

Great, it works!

 

Thank you!