topic Re: Qlikview "AVERAGEIF" function? in QlikView

Qlikview "AVERAGEIF" function?

Anonymous — Fri, 07 Apr 2017 15:20:50 GMT

Hi all,

I'm trying to average in the right most column the CSA prices of SKUs on the left. So, for example, one SKU may have three CSA prices, how do I average these three prices without removing the individual prices as a dimension?

I've tried these two formulas and neither have worked:

Avg(aggr(Avg ([Final Price]), PK_SKU))

avg({1} Final Price )

Any help would be greatly appreciated

Thanks

Re: Qlikview "AVERAGEIF" function?

vishsaggi — Fri, 07 Apr 2017 15:43:20 GMT

May be this?

= Sum(aggr(Avg ([Final Price]), PK_SKU))

Re: Qlikview "AVERAGEIF" function?

sunny_talwar — Fri, 07 Apr 2017 15:49:32 GMT

How about this

Avg(TOTAL [Final Price])

Avg(TOTAL Aggr(Avg([Final Price]), PK_SKU))

Re: Qlikview "AVERAGEIF" function?

Kushal_Chawda — Fri, 07 Apr 2017 16:53:46 GMT

=avg(total <PK_SKU> aggr(Avg([Final Price]), PK_SKU))