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.
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.
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.