Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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);
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
I didn't used any functions or calculations at all, I am just showing the table as it is, but it shows error.
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
Out of interest, what are you going to do with a table containing 210 millions rows?
Andy
Its the requirement of my client he said sometimes he need to download whole data to send to his other locations as reference data.
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
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.