Aggregate function

[prabhas277]

Hi experts,

What is the difference between the aggregate and Aggr function and what is the use of that function?

[tresesco]

Read it here:QlikView Technical Brief - AGGR

[robert_mika · Accepted solution]

Aggregation functions are function that accumulate values from multiple rows (like SUM, MIN.MAX)

Full list of Aggregation functions in Qlikview is quite large

Avg

Concat

Correl

Count

FirstSortedValue

Fractile

InputAvg

InputSum

Kurtosis

LastValue

LINEST_B

LINEST_DF

LINEST_F

LINEST_M

LINEST_R2

LINEST_SEB

LINEST_SEM

LINEST_SEY

LINEST_SSREG

LINEST_SSRESID

Max

MaxString

Median

Min

MinString

MissingCount

Mode

NullCount

NumericCount

Only

Skew

Stdev

Sterr

STEYX

Sum

TextCount

Aggr is used with other functions to returns values based on a dimension.

If you use this function with other function you can get multiple results.

Look at Qlikview help to see examples

Example

Data set

load * Inline

[ Country,City,Sales

USA,New York,20

Russia,Moskau,10

Poland,Warsaw,15

USA,Los Angeles,20

Russia, Minsk,10

Poland, Lodz,15]