Aggregate function

[#1]

Hi,

I'm new to qlikview and i would like know on Aggregate function in detail.How it helpful and mostly where we can use this function?

Please help me on this in detail if anyone knows.

[MK_QSL]

Check links from enclosed file..

[its_anandrjs]

Go through with this nice documents related to aggregation

QlikView App: Aggr()

Aggr Function.docx

[lironbaram]

in qlikview you have the basic aggregation functions like:

sum, count , avg etc. which you normally use

what aggr function does is returning a list of values for defined  dimension

for example you have a table chart that have the field region as dimension

now you want to count for each region how many countries have reach thier sales goal

here you'll use aggr function that looks something like:

sum(aggr(if(sum(Sales)>sum(Goal),1,0),Country))

so basically the aggr function is returning 1 or 0 for each country in each region.

couple of notes:

the aggr function disregards the dimension in the chart , so you need to define best for which

combination of fields calculate the aggr function.

this function do tend to work slower then simple function so you need to use it only if you must