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