Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

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

MVP
MVP

Try like:

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

Thanks @sunny_talwar, it works. 

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