topic Re: Average per month using Avg/Aggr in QlikView

Average per month using Avg/Aggr

Wed, 25 Nov 2020 16:16:04 GMT

Hi, having an issue with getting to a monthly spending customer average and wonder if someone can help - sure it's come up before but not been able to find a fix. The below is an example of the calculation I'm trying to get to, with each particular store as the dimension. So from that table I'd want to show Store 1 - 339, Store 2 - 628 and so on

	Store 1	Store 2
Month 1	342	658
Month 2	350	622
Month 3	301	599
Month 4	312	607
Month 5	378	633
Month 6	371	650
Average	342	628

Using the Avg & Aggr functions gets me to an average across the whole group of stores but doesnt show with the branch as dimension, expression = avg(aggr( sum(SpendingCustomers), Month) ??

Thanks

Re: Average per month using Avg/Aggr

sunny_talwar — Tue, 10 Oct 2017 17:12:20 GMT

May be this

Avg(Aggr(Sum(SpendingCustomers), Month, Branch)

Re: Average per month using Avg/Aggr

fatihtomruk — Tue, 03 Jul 2018 06:46:28 GMT

Thank you @Sunny, I want to extract the min and max values on StDev. How could I make this?

Re: Average per month using Avg/Aggr

qlikviewwizard — Tue, 03 Jul 2018 09:27:17 GMT

Min(Aggr(Sum(SpendingCustomers), Month, Branch)

Max(Aggr(Sum(SpendingCustomers), Month, Branch)

Re: Average per month using Avg/Aggr

sunny_talwar — Wed, 04 Jul 2018 23:04:20 GMT

Min or Max on StDev? Can you elaborate with an example?