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]

Hi

You can use Avg(ColumnName)

Regards

[#3]

Thanks ,

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

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

[#4]

Hi,

Plz share sample data if possible.

[#5]

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

[#6]

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

[#7]

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 ?

[#8]

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

[#9]

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

[#10]