topic Re: Error Out of calculation memory in Archived Groups

Error Out of calculation memory

usamabinsadiq — Wed, 23 Jul 2025 14:48:52 GMT

Dear All please help me on this,

I have created an app with QVD file as data source, My QVD file has more then 210 Millions of rows,

I loaded the data successfully in my app but my normal table showing me error, Please guide me how to resolve this issue,

I am using Qlik Sense 3.2 SR4

Re: Error Out of calculation memory

Anders_Eriksson — Fri, 19 May 2017 13:22:25 GMT

Your expressions in that table is more than the server can handle.
Try to break it down one expression at a time.

Could be just one complicated expression that is to heavy or it could be
the combination of dimensions and expressions that is to much for the server.

Impossible to tell without more information.

Re: Error Out of calculation memory

usamabinsadiq — Fri, 19 May 2017 13:28:40 GMT

please see the script for this table,

LOAD

FirstName,

MiddleName,

LastName,

Prefix,

Address,

Appartment,

City,

State,

Zip1,

Zip2,

AddressType,

PhoneFlag,

Phone,

"TimeZone",

Gender,

FileDate,

NewToBuild,

DOB_Year,

DOB_Month,

DOB_Day,

ExactAge,

"Age",

HH_Income,

NetWorth,

CreditLines,

CreditRange,

HMaritalState,

HomeOwner,

LOR,

DWELL_TYPE,

HomeMarketValue,

INT_TRAV_GENL,

INT_TRAV_US,

INT_TRAV_INTL,

INT_TRAV_CRUISE,

CREDIT_RATING,

DNC_FLAG

FROM [lib://****/03-2016-DB-LIMITEDFIELDS.QVD](qvd);

Re: Error Out of calculation memory

marcus_sommer — Fri, 19 May 2017 14:01:52 GMT

The script and the amount of data aren't really important here else the used expressions within this object which should be as simple as possible by avoiding nested if-loops and aggr- or interrecord-functions.

- Marcus

Re: Error Out of calculation memory

usamabinsadiq — Fri, 19 May 2017 14:07:49 GMT

I didn't used any functions or calculations at all, I am just showing the table as it is, but it shows error.

Re: Error Out of calculation memory

marcus_sommer — Fri, 19 May 2017 14:19:15 GMT

You need some method to limit the max. amount of records in the object. A tablebox or a table-chart is only usable until a few hundreds or maybe thousands of records but not many millions - which then hits the memory-threshold for this object. In qlikview you could just use calculation-conditions as an option within the object by sense I don't know if this is natively or per extension available. If not I think any workaround will be possible maybe with a condition in a dimension or expression by a table-chart.

- Marcus

Re: Error Out of calculation memory

awhitfield — Fri, 19 May 2017 14:27:29 GMT

Out of interest, what are you going to do with a table containing 210 millions rows?

Andy

Re: Error Out of calculation memory

usamabinsadiq — Fri, 19 May 2017 14:52:27 GMT

Its the requirement of my client he said sometimes he need to download whole data to send to his other locations as reference data.

Re: Error Out of calculation memory

marcus_sommer — Fri, 19 May 2017 15:02:11 GMT

Even if the object could display so much records the export of the data would be take a very long time - probably more as practically and I assume there would be other issues too.

Therefore I think you should create a specialized load for it which stored these data into txt-file and send it to the client or give him access to it.

- Marcus

Re: Error Out of calculation memory

Anders_Eriksson — Mon, 22 May 2017 07:31:26 GMT

Agree with Marcus, why doing in the GUI?

Showing a table-box with millions of rows is pointless to a user, can't interact with it even if it shows.
If you don't use all that data in other GUI objects it is of no use and it will considerably slow down the whole application.

Either do a load and store to file in script or do a export directly in the database.

You already have it as QVD, you could as easily store it as a CSV and give to your client.