Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average per month using Avg/Aggr

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 1Store 2
Month 1342658
Month 2350622
Month 3301599
Month 4312607
Month 5378633
Month 6371650
Average342628

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

1 Solution

Accepted Solutions
sunny_talwar

May be this

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

View solution in original post

4 Replies
sunny_talwar

May be this

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

fatihtomruk
Contributor III
Contributor III

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

qlikviewwizard
Master II
Master II

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

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


sunny_talwar

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