topic Duplicate value in Pivot Table when using Aggregation function in Dimension in QlikView

Duplicate value in Pivot Table when using Aggregation function in Dimension

mrthomasshelby — Wed, 16 May 2018 12:53:10 GMT

Hello,

I have a pivot table as below:

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

Re: Duplicate value in Pivot Table when using Aggregation function in Dimension

sunny_talwar — Wed, 16 May 2018 13:27:41 GMT

Change your calculated dimension to this

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

Re: Duplicate value in Pivot Table when using Aggregation function in Dimension

mrthomasshelby — Thu, 17 May 2018 07:00:07 GMT

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!

Re: Duplicate value in Pivot Table when using Aggregation function in Dimension

sunny_talwar — Thu, 17 May 2018 08:48:10 GMT

I am not sure what caused it...

Re: Duplicate value in Pivot Table when using Aggregation function in Dimension

mrthomasshelby — Thu, 17 May 2018 08:50:33 GMT

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.