topic Re: Allocated memory exceeded - dimension limits in QlikView

Allocated memory exceeded - dimension limits

Thu, 01 Nov 2012 18:31:10 GMT

I have a straight table and I need to get the top largest 25 amounts based on my first expression. My first expression is this..

if(vShowWindow='% CHANGE',((column(7)/Column(8)))-1,if(vYearIndicator='Current' and $(CurrentBilling)>= vTreshHoldSize,$(CurrentBilling),if(vYearIndicator='Prior' and $(PriorBilling)>= vTreshHoldSize,$(PriorBilling))))

I tried using the 'Dimension Limit' tab by selecting Largest and entered 25 however, I am getting 'allocated memory exceeded' message. I can get this to work if I go to the 'Presentation' tab and enter in 25 in the Max Number and sort descending on the first expression. The problem with this is that I have a threshold text box that users enter in and it does not seem to sort or I am getting some funky results. I would really like to use the dimension limits but it is not working. Any thoughts? Is this a bug?

This problem is happening in QV 11 SR1 and SR2.

Re: Allocated memory exceeded - dimension limits

MayilVahanan — Thu, 01 Nov 2012 18:49:46 GMT

Try rank function..

=if(rank(sum(sales)<= 25, sum(Sales))

it display highest 25 values.

Hope it helps

Re: Allocated memory exceeded - dimension limits

Fri, 02 Nov 2012 17:23:34 GMT

After some trial and error, I found that the below calculation (in red) in the below expression was causing the allocated memory exceeded issue.

=if(vShowWindow='% CHANGE',((column(7)/Column(8)))-1,if(vYearIndicator='Current' ,$(CurrentBilling),if(vYearIndicator='Prior',$(PriorBilling))))

If I remove the above calculation (in red) and replace it with the actual formula titles, i no longer get the error.

=if(vShowWindow='% CHANGE',(($(CurrentNormalShare))/($(PriorNormalShare)))-1, if(vYearIndicator='Current',$(CurrentBilling),if(vYearIndicator='Prior',$(PriorBilling))))

So far it is working...

Re: Allocated memory exceeded - dimension limits

MayilVahanan — Fri, 02 Nov 2012 17:27:45 GMT

Got your requirement means happy

Check once with it,

(column(7)/Column(8))-1,

edit:

also test it:

(column(7)/column(8)) gives value? if so, then no probs in your expression..

Regards,

R.Mayil Vahanan.

Re: Allocated memory exceeded - dimension limits

Fri, 02 Nov 2012 20:59:30 GMT

Thank you for your input Mayil,

I did test (column(7)/column(8)). It still gives me an "allocated memor exceeded" message. It seems you must implicitly use the formula titles in order for the below expression to work with dimension limits.