topic Re: Aggregate function in QlikView

Aggregate function

Thu, 24 Apr 2014 11:06:33 GMT

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 — Thu, 24 Apr 2014 11:09:21 GMT

Check links from enclosed file..

its_anandrjs — Thu, 24 Apr 2014 11:15:50 GMT

Go through with this nice documents related to aggregation

lironbaram — Thu, 24 Apr 2014 11:17:58 GMT

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