topic Re: Allocated memory exceeded error in pivot table in QlikView

Allocated memory exceeded error in pivot table

udaya_kumar — Wed, 18 Nov 2015 06:50:51 GMT

Hi,

I have a pivot table with 5 dimensions and an expression.

I have added 4 field dimension and 1 calculated dimension.

If i add all field dimension, then the pivot table shows data, if i add one calculated dimension like below

=Aggr(Only({<Date={">=$(=Date(MonthStart(AddMonths(Max(Date),-11)),'MMM-YY'))<=$(=Date(MonthEnd(Max(Date)),'MMM-YY'))"}>} Date),Date)

If i add the above expression in dimension, I am getting "Allocated memory exceeded" error, but if add Date as the dimension, then it works fine. What is the issue here?

Can someone please help me?

Re: Allocated memory exceeded error in pivot table

jonathandienst — Wed, 18 Nov 2015 07:16:57 GMT

I suspect that your date field has a time component as well, therefore it has a high cardinality and the vector created by Aggr() is massive (and running out of memory).

When you load the date, drop the time component or split out the time if you need the time value:

LOAD

...

...Date(Floor(SourceDateField)) As Date,

...Time(Frac(SourceDateField)) As Time, // if you need the time.

...

(Note the Date() function does not truncate the time part - it merely formats the value. You need the Floor() to do that)

This will simplify the Aggr() calculation.

Re: Allocated memory exceeded error in pivot table

udaya_kumar — Wed, 18 Nov 2015 07:18:19 GMT

Hi,

I had added the similar Aggr expression in other pivot table, there it is working fine.

So i copied that pivot table and added this table dimension and expressions in that other pivot table and it is working fine. I don't know what is the problem with the pivot table.