topic Re: Allocated memory exceeded in QlikView

Allocated memory exceeded

dickelsa — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have a problem with my QV file. When I try to change a color of my Pivot table, and I press 'apply' the pivot table turns into a blank with only the text: 'allocated memory exceeded'.

I did nothing with any synthetic fields, I only typed 'LightGreen([field])' in which 'field' is the fieldname. I did this in the tab Dimensions.

Can anyone tell me how to solve this? I heard this was some kind of bug..

Thanks in advance.

Regards

Re: Allocated memory exceeded

MK_QSL — Sat, 05 Oct 2013 10:34:29 GMT

Are you trying to do background color of PIVOT table or specific column's color?

Please upload your file to understand your question.

Re: Allocated memory exceeded

Sat, 05 Oct 2013 10:43:50 GMT

try to reload your Data i think it will solve your problem

Re: Allocated memory exceeded

Brice-SACCUCCI — Mon, 07 Oct 2013 08:08:27 GMT

Hi,

normally, this happens when you are trying to show too many values on your table or when computing the table takes too much memory, depending on the RAM that is available on your computer / server.

This is not intuitively linked to the changes you are making to the table. If you keep it this way, the risk is that the message will appear "randomly" when the load is too high, looking like it's a bug.

Reloading, re-opening the app and stuff like this will just be a temporary fix but will not solve the root of the problem.

You have to try to reduce the amount of data you want to include in the table (think about the user experience) or use a machine with more RAM if you cannot shrink it further.

Regards,

Brice

Re: Allocated memory exceeded

dickelsa — Wed, 09 Oct 2013 07:17:33 GMT

Hi,

I actually am trying to colour the background of the header of 1 row in the Pivot table indeed.

Reloading the data does not seem to work.

Re: Allocated memory exceeded

dickelsa — Wed, 09 Oct 2013 07:24:04 GMT

Hello,

Believe me, the RAM is not a problem, I have got a lot of that. I minimized the data and it is still not working. i will upload a version after I anonymised some data.

Regards

Dick

Re: Allocated memory exceeded

CELAMBARASAN — Wed, 09 Oct 2013 07:24:53 GMT

May be the Field doesn't have the relationship with the expressions/dimension you have in the table. Check the Relationship between the tables in the table viewer.

If thats correct then problem is More number of records and low RAM.

Re: Allocated memory exceeded

Wed, 09 Oct 2013 07:30:54 GMT

Hi Dick,

I certainly agree with Brice on the above he just mentioned.

Reloading is a temporary fix,its not something that will permanently solve your problem.

You can try something like this:

(See attached)

Try and adjust the transparency as per you choice,if its green that you want.

Re: Allocated memory exceeded

dickelsa — Wed, 09 Oct 2013 08:21:04 GMT

The records in the field have relationships with the data. I first made the table work without any colours... the RAM on my computer is not the problem.

Re: Allocated memory exceeded

dickelsa — Wed, 09 Oct 2013 08:24:07 GMT

Hello Rochelle

Thanks for your imput, but I am trying to color the background of 1 specific cell, not the colour of the entire table.

Regards

Dick

Re: Allocated memory exceeded

Wed, 09 Oct 2013 08:30:59 GMT

Hi Dick,

What you can do is:

1) Define all your headers in one inline table.

2) use the inline table in your pivot chart,and drag it to the right side,so that your field data will appear as columns and then in the dimension properties,set background colour as LightGreen()

Re: Allocated memory exceeded

sudeepkm — Wed, 09 Oct 2013 08:44:48 GMT

I recently have seen Out of Object memory issue in one of our QVWs while using a pivot table with full expansion mode.

I was surprised to see that with just 120K records and the QVW file size of 14 MB was taking a RAM size of 20 GB.

We resolved this issue by using simplified version of the expressions.I had nested if else in my expression. I changed them all to conditional display and used set analysis.

So my suggestions is:

1. Open the QVW in your local and open the task manager and test how much memory the Qv.exe process is taking

2. If you have used any if else logic then try to avoid it and use simple expression. Better to use set analysis wherever possible.

If you can also attach the scrambled copy of the qvw then I could test this in my system.

Re: Allocated memory exceeded

CELAMBARASAN — Wed, 09 Oct 2013 09:25:37 GMT

Could you please attach file to look at it.

Re: Allocated memory exceeded

dickelsa — Wed, 09 Oct 2013 10:56:10 GMT

Rochelle,

I think you misinterpeted my problem.

I know the ways to do it, but it does not work, because when I do it, QV says that my allocated memory is exceeded.

kind regards

Dick