Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

loading huge data to excel file

Hi,

i have a huge data around 1lacs rows with 200 columns to be add and displayed in qlikview and also need to export that to excel. can anyone help me to get this done..

Regard,

Grace Rashmi

6 Replies
Not applicable
Author

i am trying load the raw data in straight table. since the data is huge im getting as error as 'object out of memory' and not loading to exporting to excel also...

Gysbert_Wassenaar

The only way to deal with that is add more ram to your machine. Or don't load that data in a straight table. If the only reason is to be able to export that data then try doing that in the script with the STORE statement and export the table to a csv file.


talk is cheap, supply exceeds demand
Not applicable
Author

I tried.. Data is huge it is giving error.. plz help me

Error- "Excel cannot complete this task with avaialble resources. Choose less data or close other applications."

Not applicable
Author

Hey try to export in XLSX format it works.

khadeer
Specialist
Specialist

As per excel it cant export that much of data.

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

This has absolutely nothing to do with QlikView. The issue is with your computer, I think.