Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

AAALR() greater than 1.000000

Can anyone point me to the appropriate place in Sense to fix the AAALR() greater than 1.000000 issue?

2 Replies

Response regarding this issue, from Qlik was, when raised by different people:

Check this link:

Response 1:

AAALR refers to the average length of the aggregation array. For some customers who have large data sets, poor response times ,and/or complex calculations this warning will present in their logs. The general fix for this is to add this entry to the [Settings 7] portion of the Settings.ini for QlikView Server on all nodes:


This will switch to a new aggregation array which improves performance.

Response 2:

The warning to which you are referring - QVGeneral: when AAALR(1.293973) is greater than 1.000000, we suggest using new row applicator to improve time and mem effeciency. AAALR" is a very low level concept deep in the QlikView engine. Generally speaking it means the average length of aggregation array. The longer this array is, the more RAM usage and CPU power are to be consumed by the engine to get aggregation result for every hypercube node and can thus effect performance.

When AAALR is greater than 1.0, normally the customer has a large data set and suffers slow responses and high memory usage in their app.

To mitigate this, you can add the below setting to the Settings.ini file located in the QlikTech\QlikViewServer:


By setting this parameter to “0”, QlikView will use an new algorithm which is optimized for large data set to do the aggregation, and will consume much less RAM and CPU power.


Tweak your data model as per this:

The Importance Of Being Distinct