I have an requirement to export to excel the larger data like 1 Million records from the Qlikview through the Accesspoint. As we have the default export excel functionality upto 65K records it exports to excel after that it converts into CSV.
But my requirement is, it should be export excel. Because this data client will import into CRM System,Is there any possibility.
I have tried with the changing of RowLimitForCsvInsteadOfXls=10000000 cap limit in the settings of Qlikview. but i coulsn't succeed.
The problem is not Qlikview, but Excel. Excel cannot hold this huge number of records in one single file.(I experience the same issue). A solution we use is to chunk the big file into several smaller ones that Excel will allow.
If your client can upload multiple excel files, then you could first assign a unique number to each record through 'Recno = AutoNumber()'. Then through a loop, you fetch a certain number of records (allowed by Excel). We did this as followed (see below).
This allowed us to treat 128 (2 power7) at a time. (you may choose much bigger intervals) Within each iteration, you can then save the file in Excel, adding the $(i) in your saving instruction. That will save you a number of files equal to your number of iterations.
SETl=Null(); LETk = 7;
LETpwr2x=Pow(2,$(k)); SETk=Null(); FORi = 1 to XXX (depending on the total number of records you have and your selection width)