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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unable to export data as an excel from straight table

I have created a straight table with  150 + fields and was trying to export as an  excel . It is giving an issue of

" hypercube results are too large "in qlik sense.

Please help ! 

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

150+ fields!? Uhm, Qlik Sense is not an ETL tool that just happens to also have a fancy UI that can product some pretty charts. If you need an excel file with 150+ columns then you're probably using the wrong tool. That's probably excel, but perhaps you have no control over that. In that case find a way to transform the source data with a real etl tool and export to excel from there.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

150+ fields!? Uhm, Qlik Sense is not an ETL tool that just happens to also have a fancy UI that can product some pretty charts. If you need an excel file with 150+ columns then you're probably using the wrong tool. That's probably excel, but perhaps you have no control over that. In that case find a way to transform the source data with a real etl tool and export to excel from there.


talk is cheap, supply exceeds demand
Not applicable
Author

Ha ha , I was expecting this . Thanks

Not applicable
Author

how much is the maximum size can we export  ?

I am just curious if any one could answer.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I think that mostly depends on the amount of ram in your machine. But I don't export masses of data to excel so I don't have a good idea of the limits.


talk is cheap, supply exceeds demand