12 Replies Latest reply: Oct 5, 2010 8:26 AM by Ronald Calolot

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

• ###### How to calculate average of a column?

Hi

You can use Avg(ColumnName)

Regards

• ###### How to calculate average of a column?

Thanks ,

i've tried Avg(column name) and Avg(column(no)) but it didnt work :(

just Avg(field) works, i dont know why ?

• ###### How to calculate average of a column?

Avg(ColoumnName) sholud work............ anyways can u send demo application

• ###### How to calculate average of a column?

Hi sir,

What is the name of the column you want to get the average? Avg(ColumnNameHere) should work fine. Well if your Column Name or field name consist of 2 or more words for example: Column Name (with space) you should enclosed it with brackets eg: Avg([Column Name])

Regards

• ###### How to calculate average of a column?

The column names have more than two words, Avg([Column Name]) may work. i'll try.

the document is about 25 mb how can i send it, or share here ?

• ###### How to calculate average of a column?

Uhm...its not neccessarily to upload the whole file just a sample will do. You can also post screen shots so that we can see/analyze your problem clearly.

For the meantime please try to use Avg([Column Name])

• ###### How to calculate average of a column?

Avg([Column Name]) doesnt work too, here is the screenshot

• ###### How to calculate average of a column?

Hi,

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

Regards

• ###### How to calculate average of a column?

OK,

thank you all very much..

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

Best Regards

• ###### How to calculate average of a column?

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!

• ###### How to calculate average of a column?

Hi,

Plz share sample data if possible.