Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
MVP & Luminary
MVP & Luminary

Re: Unable to export data as an excel from straight table

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
4 Replies
MVP & Luminary
MVP & Luminary

Re: Unable to export data as an excel from straight table

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

Re: Unable to export data as an excel from straight table

Ha ha , I was expecting this . Thanks

Not applicable

Re: Unable to export data as an excel from straight table

how much is the maximum size can we export  ?

I am just curious if any one could answer.

MVP & Luminary
MVP & Luminary

Re: Unable to export data as an excel from straight table

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