Discussion Board for collaboration related to QlikView Deployment.
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.
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.
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.
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.
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:
Try and adjust the transparency as per you choice,if its green that you want.