Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mrthomasshelby
Creator III
Creator III

Duplicate value in Pivot Table when using Aggregation function in Dimension

Hello,

I have a pivot table as below:

QV123.png

I'm using an aggregation function in the expression for calculating Company Estimate as a dimension. As you can see, P1 is giving the same aggregated sum twice and splitting the measures. Does anyone have any idea why this is happening? I'm also attaching the app to the post. Thanks in advance!

stalwar1

1 Solution

Accepted Solutions
sunny_talwar

Change your calculated dimension to this

=num(Aggr(Avg(Aggr(Sum([Cost Estimate]),[Package Name], Supplier)), [Package Name]),'#,###.0')


Capture.PNG

View solution in original post

4 Replies
sunny_talwar

Change your calculated dimension to this

=num(Aggr(Avg(Aggr(Sum([Cost Estimate]),[Package Name], Supplier)), [Package Name]),'#,###.0')


Capture.PNG

mrthomasshelby
Creator III
Creator III
Author

Hi Sunny. This fixed the issue. Do you have any idea as to why this was happening? Just to know so that I can avoid such things in the future. Thanks a lot again!

sunny_talwar

I am not sure what caused it...

mrthomasshelby
Creator III
Creator III
Author

That's okay. I'll try going through my data model and see if anything looks out of place and might cause this issue. Thanks a lot for the help.