How to calculate average of a column?

[#1]

Hi Community,

As a very new user of QlikView i need some help about the case below :

On a pivot table visual cues tab, i'm trying to define upper/lower levels as some values depending average of expressions. in the formula box (edit expression) how to calculate the average of expression (column) ?

[#2 · Accepted solution]

Hi,

I attached my sample qvw file. The Avg([Net Sales]) works fine. Please compare this to your work.

Regards

[#3]

OK,

thank you all very much..

this is a very helpful community, i'm very glad for joining here..

Best Regards

[#4]

Your right! This forums has great people! I'm also a beginner but learned many things from these great people! (Since I have no proper training just learning by experience)

Good luck!