topic Re: Allocated Memory Issue in QlikView

Allocated Memory Issue

dhanavindhan — Tue, 12 Dec 2017 09:03:49 GMT

Hi,

I am facing this issue "Allocated Memory Exceeded" when I try to open one of the Pivot table in Qlikview sheet. I tried my level best to sort this issue but I couldn't. If any one know better solution to resolve this please enlighten me to sort this out.

Re: Allocated Memory Issue

vvvvvvizard — Tue, 12 Dec 2017 09:18:37 GMT

One of the reasons this may occir is if there are data islands in the table structure . Does your table use a field that belongs to a data island?

Re: Allocated Memory Issue

dhanavindhan — Tue, 12 Dec 2017 09:57:25 GMT

Hi Yusuuf,

Thank u for ur reply. I don't understand what is "Data island" are u mentioning "Data Model"?

Re: Allocated Memory Issue

supriyabiware — Tue, 12 Dec 2017 10:01:17 GMT

i think the error can happen even when you expression has syntax errors!

there is something about the if condition - kindly check syntax again

=if(condition 1 or condition 2, exp1, exp2)

Thanks

Supriya

Re: Allocated Memory Issue

dhanavindhan — Tue, 12 Dec 2017 10:22:03 GMT

Hi Supriya,

Thnq for ur quick reply. The thing is if I am loading this table with limit load it works perfectly. I am getting this allocated memory issue only when I reload full data. If expression was wrong how it works in limit load, is there any other cause or pls highlight me the expression area.

Regards,

Dhana

Re: Allocated Memory Issue

supriyabiware — Tue, 12 Dec 2017 11:35:48 GMT

ok how much is your data ?

check for RAM available as well. if limited load is working i think the RAM might be an issue.

Re: Allocated Memory Issue

marcus_sommer — Sat, 16 Dec 2017 09:31:55 GMT

There are too many if-loops within your expressions especially in the type of sum(if(... instead of if(...sum(... whereby I don't suggest to re-write them in this way else a far better way would be to use set analysis. The logic and syntax are a bit more complex as with the if-loops but in the long-term you will definitely need this knowledge. Here is a very good starting point for this task: A Primer on Set Analysis.

- Marcus

Re: Allocated Memory Issue

dhanavindhan — Mon, 18 Dec 2017 04:15:17 GMT

Thank you for your valuable reply, Marcus.