Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ericus
Contributor II
Contributor II

Aggregate Sum function does not match

Ok, so I've encountered a problem I can't seem to figure out the reason as to why it is happening.  My summation in the pivot table does not equal the total of the availible data points. Sum([Belopp Brutto]) should aggragete over all facilities 9260311015, but it gets a higher value. It is accurate for several other facilities, but not some have shouldn't so I guess my question is what am I missing?

Ericus_0-1644510449684.pngEricus_1-1644510488261.png

 

Labels (1)
1 Solution

Accepted Solutions
albertovarela
Partner - Specialist
Partner - Specialist

Something tells me you have a couple of duplicated records. Create a table with Dim: Anlaggning and measure: Count(Anlaggning).  Select that same value from your screenshot and I bet you'll get a count > 3.  I hope this helps

View solution in original post

1 Reply
albertovarela
Partner - Specialist
Partner - Specialist

Something tells me you have a couple of duplicated records. Create a table with Dim: Anlaggning and measure: Count(Anlaggning).  Select that same value from your screenshot and I bet you'll get a count > 3.  I hope this helps