What is Aggregation function?

[jonesbrown]

Hi All,

I am new to Qlikview

What is Aggregation function?

Plz Help.

[YoussefBelloum · Accepted solution]

this one is duplicate

What is Aggregation function?

[Emma]

A Wiki search that explains the concept very well:

In database management an aggregate function is a function where the values of multiple rows are grouped together to form a single value of more significant meaning or measurement such as a set, a bag or a list.

Common aggregate functions include :

• Average() (i.e., arithmetic mean)
• Count()
• Maximum()
• nanmean() (mean ignoring NaN values, also known as "nil" or "null")
• Median()
• Minimum()
• Mode()
• Sum()

Hope that helps.

You can use them in creating variables or in your expressions.

Best