Out of Object Memory Issue

[#1]

Hi Guys,

Do you ever have to deal with the Out of Object Memory Issue in Qlikview ?

I create a qvw file with 4 years of data - total records around 400 millions.

The offended sheet - was made of pivot chart with 4 cyclics with regular sum as the calculation, whenever i try to pull the 3 years of data - it always give me the "Out of Object Memory" Error and none got displays

40 G memory and 64 bit Windows Server 2008 and Quad Core Xeon 2.33 Mhz.

Qlikview 8.5.

Any help will be appreciated.

[#2]

if Age=18 ,sum(cost18) , sum(cost25) - --- I just mistyped before

[#3]

Hi,

had the same problem. In your case, may be the solution is to change your formula as follows:

1 expression:

sum ({$<Age={'18'}>}, cost18)

2 expression:

sum ({$<Age={'18'}>}, cost25)

Hope this helps...

[#4]

Yes - that is the only solution.

Thanks