topic Re: Exclude field selections for average in QlikView

Exclude field selections for average

Tue, 28 Apr 2015 15:14:59 GMT

Hello,

I want to calculate the average of units sold (#) for region (Regionaam) and I have three regions; noord, west and Zuid. I want to calculate the average in pivot table but if I select one of the regions, I get the number of units sold for that region and I want to see the average instead. Please help me?!

Thank you

Best,

Re: Exclude field selections for average

sunny_talwar — Tue, 28 Apr 2015 15:16:40 GMT

Try it with total:

Avg(TOTAL [Units Sold])

Re: Exclude field selections for average

Tue, 28 Apr 2015 15:25:59 GMT

thank you for your reply, but I tried that. this is the expression i was using.

AVG(TOTAL<LandBestemming>aggr(sum({1<LandBestemming={'NL'}, $(v.Actual) ,$(v.PeriodYear)>}#),LandBestemming))

Re: Exclude field selections for average

sunny_talwar — Tue, 28 Apr 2015 15:28:41 GMT

Would you be able to share a sample?

Best,

Sunny

Re: Exclude field selections for average

Thu, 14 May 2015 12:35:51 GMT

Thank you Sunny for your help!

I found the right expression I need which is this:

Avg(Aggr(sum({< Regionaam=P(Regionaam),$(v.Actual),$(v.PeriodYear)>}[Units sold]), Regionaam)) I was using LandBestemming instead of Regionaam