Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate average of a column?

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) ?

12 Replies
Not applicable
Author

Hi,

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

Regards

Not applicable
Author

OK,

thank you all very much..

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

Best Regards

Not applicable
Author

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!