more than 1048566

[Qlik_FZ]

Dear all,

I have table object with multiple dimensions and measures....and I have rows 3 million rows.
while exporting I am getting below message and in only 1048566 rows exported.

is there any way to export in multiple excel sheet(tab) such as first sheet 1048566 then next is starting from 1048567 and like this ....?

or what else solution we have ? 

[GOKULAKANNAN]

Hi @Qlik_FZ ,

This is a limitation of Excel, its limited to only 1 million records per sheet, to overcome that, you have to follow pagination concept, where you can split the pages using a row number function and you can place multiple sheets and each sheet will hold 10 laks records.

[vinieme12]

IMHO : If you are using QlikSense to do datadumps then you are using the wrong tool

having said that; why not use the STORE INTO CSV during data load; instead of front end export ?

[GOKULAKANNAN]

Hi @vinieme12 ,

Yeah that can be done, but If user wants to apply certain filters and export the data, then we have to use the traditional approach only, even if we store in CSV there is also limitation for rows of data.

[vinieme12]

You can still have an ODAG solution to filter and trigger a reload to dump the data 

and to apply Pagination ; they must need Nprinting to do so for an On-Demand report

but in all not a good use of resources simply for exporting data 

[GOKULAKANNAN]

Yeah @vinieme12  agreed, Business users simply using qlik as an intermediate tool to export the data, they are not understanding that all the analysis can be done in Qlik itself, and ODAG is also let you create a seperate app with applied filters, but again if the data volume is huge, they will face the same export problem in ODAG as well. also, its not recommended to use export to excel with huge data as it will lead to utilization of RAM in high level.

[Qlik_FZ]

Pagination ??How to do this?

[GOKULAKANNAN]

Hi @Qlik_FZ , To do that, you need to have N-Printing , through that you can achieve that

[Qlik_FZ]

No we are not looking for solution to use N-printing as simple. We need to check if we can achieve this using qliksense only ?

[vinieme12]

Simply split your data into more than 1 table instead

example table1 is filtered for data for RegionX and table2 with data for RegionY

Since your data volume is larger than what excel can handle, you will inevitably need to split this into multiple tables