Discussion board where members can get started with Qlik Sense.
I am making a straight table in qlik sense.i used 1 dimension which have 700000 row and caluclate 52 measure. in qliksense. but is it showing error like The hypercube results are too large.what's the meaning of this error. And Why not exporting.
first of all this is huge !
I don't know the purpose of your client or your need but you simply don't use the full capacity of Qlik Sense for your need.
The best way to analyze your table is a better and ergonomic app in order to find key indicators and get a quick view of your KPI's in order to make decisions.
Anyway, as I said every needs are different. In your case there is a maximum amount of rows and columns handled by Sense :
The default maximum number of rows and columns in the Excel export file is:
You will find more info here :
Yes but I saw somewhere on the forum Qlik sense is limited to a max number of 1 000 000 cells in your export (old thread).
The best way to achieve what you are doing is using Sense correctly.
I mean there is no point in doing that from the interface as your only goal is to export your data.
1) make all your measures calculation based on your only dimension directly in the script
2) Store the table in a CSV ou XLSX file.
3) Create a task to automate the process (if you wish to have refreshed data).
4) If you have to share your data put store your file on a network share
This should solve your problems.
As Laurent mentioned, there does has a limitation of the cells in qliksense.
See discussion here.
On the other hand, why do you want to export such a big excel, I think no one will read such a big table at once, except you will use it as the data source for other tool.
If you do want to export the whole table, You can using nprinting and filter to export it.