topic How to Calculate Average of Numbers? in QlikView

How to Calculate Average of Numbers?

R0b — Wed, 18 Jan 2023 13:28:43 GMT

Hi all,

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

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

hic — Wed, 18 Jan 2023 14:29:04 GMT

Try

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

R0b — Wed, 18 Jan 2023 15:36:19 GMT

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

Thank you!