Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Sefib
Contributor
Contributor

How to calculate Sales AVG per customer

Hi Everyone ,
I'm new to qlik sense and I need to create KPI dashboard for an interview exam.
I'm trying to calculate sales AVG per customer.
I tried the following expression, but it didn't work as expected:
Avg(Aggr(Sum(AMOUNT), CustomerID))
Expected Result: 4,838
Actual Result: 4,785
Attached Sales.qvd file
I would appreciate your help 🙂

4 Replies
rafael_neves
Contributor III
Contributor III

Hello, how are you?
the formula seems to be right, can not find the attachment, can you send again?

graciously
Rafael Yoshida

Sefib
Contributor
Contributor
Author

Hi Rafael,

Thanks for your quick replay :-).

I experienced some technical issue uploading the file.

Can I send it to you by email?

Thanks,

Sefi

rafael_neves
Contributor III
Contributor III

clear

yoshida@yoshidaqlik.com.br

rafael_neves
Contributor III
Contributor III

Hi

Is there a filter you need to do?
in the file sent the AVG number does not match the one entered

Modelo.PNG

 

graciously

Rafael Yoshida