Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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!