Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

Nedd help in Average of Averages

Hi all

I have 5 charts depicting averages across months of 5 different metrices for each of our 6 outlets.

I would like to create a new chart showing an Average  of the  Averages of the materices for each outlet and/or Average of the Averages for the whole company.

How would I go about showing the average of the averages?

Thanks

Josh

1 Reply
Gysbert_Wassenaar

I think you'll need the aggr function. Read this document for an explanation of the aggr function. If you need help you'll have to post more information. Read this howto for creating an example document for upload.


talk is cheap, supply exceeds demand