Allocated memory exceeded

azimabadi — Tue, 08 May 2012 09:36:28 GMT

Hi everybody,

I have a funny problem today . Of course i look like this .

anyway, i have a sub in my macro looks like this:

SUB mySub2

set Sheet = ActiveDocument.CreateSheet

set chart = Sheet.CreatePivotTable

chart.AddDimension "Field1"

chart.AddExpression "1"

END SUB

when i call it from my interface, a new sheet is created and also the PivotTable. But PivotTable shows the error message "Allocated memory exceeded".

What that is funny is, when i openthe properties dialog of PivotTable, then click on "Dimension" tab and then click "OK" Button, the PivotTable shows data.

I have to click the "Dimension" tab first, otherwise the error is there.

I think the PivotTable needs some sort of refresh, i tried chart.Deactivate and then chart.Activate but it dosen't work.

Thanks forward for any Idea.

P.S. : I work with QlikView for Windows 11 SR1 x64

Best regards

Peyman

Allocated memory exceeded

azimabadi — Wed, 09 May 2012 13:24:59 GMT

DING!

topic Allocated memory exceeded in QlikView

Allocated memory exceeded

Allocated memory exceeded