Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
usamabinsadiq
Contributor III
Contributor III

Error Out of calculation memory

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

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.
Labels (4)
9 Replies
Anders_Eriksson
Partner - Specialist
Partner - Specialist

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.

usamabinsadiq
Contributor III
Contributor III
Author

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);

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.
marcus_sommer

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

usamabinsadiq
Contributor III
Contributor III
Author

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

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.
marcus_sommer

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

awhitfield
Partner - Champion
Partner - Champion

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

Andy

usamabinsadiq
Contributor III
Contributor III
Author

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

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.
marcus_sommer

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

Anders_Eriksson
Partner - Specialist
Partner - Specialist

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.