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: 
Not applicable

aggregate function problem

I have a table as follows:

1.JPG.jpg

And when I apply the aggregate function on duration as aggr(sum(DURATION),SYSTEM_ID)  , I get the values totally scaled up.. I noticed they are multiplied 7 or 6 or 5  times than the expected values what could be the reason, the aggregated table is as follows:

2.JPG.jpg

2 Replies
maxgro
MVP
MVP

Not applicable
Author

I have seen this in a few cases where there are duplicates.

Just try sum(aggr(sum(distinct DURATION),SYSTEM_ID)). This is not a solution but can help identify if there are duplicates in your model.

Thanks

AJ