topic Used of Aggr() Function in QlikView

Used of Aggr() Function

Thu, 17 Sep 2015 03:21:27 GMT

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

Re: Used of Aggr() Function

Gysbert_Wassenaar — Thu, 17 Sep 2015 05:47:25 GMT

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).

Re: Used of Aggr() Function

jafari_ervin — Thu, 17 Sep 2015 06:03:24 GMT

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.