Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Average per Customer

Hi There,

i want to calculate an Average Prive per Item per Customer.

But i am Stuck 😞

The average is not correct, if there are 2 Prices per customer. I Played around with aggr and total, but it is not working.

AVG.png

I want the average of the average per customer (see attached Excel) as an result. But it is not Working 😞

I rellay would appriciate some help!

 

Thanks

Fabian

Labels (1)
1 Solution

Accepted Solutions
Highlighted

I think this is what you need

=Avg(Aggr(Avg(Price),Customer))

But for some reason, you excluded Customer I for your expected output. If you want to exclude I, you can try this

=Avg({<Customer -= {'I'}>}Aggr(Avg(Price),Customer))

View solution in original post

3 Replies
Highlighted

I think this is what you need

=Avg(Aggr(Avg(Price),Customer))

But for some reason, you excluded Customer I for your expected output. If you want to exclude I, you can try this

=Avg({<Customer -= {'I'}>}Aggr(Avg(Price),Customer))

View solution in original post

Highlighted
MVP
MVP

Try like:

=Avg(Aggr(avg(Price), Customer))
Highlighted
Creator II
Creator II

Thanks @sunny_talwar, it works. 

I did not want to exclude I, i made mistake 😞