Used of Aggr() Function

[#1]

Hi,

I have a question about AGGR function,

I don't really know what happen when I'm using this function, i have read that aggr will create virtual/temporary table. but still dont understand what the system do when aggr function execute.

aggr(expression, dimensions)

I also confuse about the dimension in aggr function, are every dimension in my application must be define in dimension section ?

Really need your help.

Thanks

[Gysbert_Wassenaar]

Have you read this document already? QlikView Technical Brief - AGGR.docx

In the aggr function the dimensions have to be field names that are loaded/created in the load script. You can't use calculated dimensions (which can only exist in charts, but don't exist in expressions) or expressisons (with one exception).

[jafari_ervin]

The aggr function calculated your expression with respect of dimension or dimensions you define, if you are familiar with sql, aggr function do the same job like group by in sql.

I also confuse about the dimension in aggr function, are every dimension in my application must be define in dimension section ?

You can do this but is not necessary.