Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
R0b
Contributor II
Contributor II

How to Calculate Average of Numbers?

Hi all,

I'm hoping you can help me calculate the average for a set of numbers in a pivot/straight table?

Snapshot Date Variance
31/07/2022 151
31/08/2022 188
30/09/2022 116
31/10/2022 115
30/11/2022 -51
31/12/2022 28

 

As you can see, my dimension is [Snapshot Date]

My formula for the variance is =Sum([Active Count]) - Above(Sum([Active Count]))

How can I get an average of these numbers into a text box? 

 

Thanks,

 

Rob

Labels (2)
1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Try

Avg(Aggr(Sum([Active Count]) - Above(Sum([Active Count])),([Snapshot Date],(NUMERIC,ASCENDING))))

View solution in original post

2 Replies
hic
Former Employee
Former Employee

Try

Avg(Aggr(Sum([Active Count]) - Above(Sum([Active Count])),([Snapshot Date],(NUMERIC,ASCENDING))))

R0b
Contributor II
Contributor II
Author

This worked. With your answer and a bit of help from a colleague we managed to come up with the right solution. 

Thank you!