topic Re: Trying to Export 85,000 rows into Excel from Qlikview in QlikView

Trying to Export 85,000 rows into Excel from Qlikview

Wed, 22 Jan 2014 00:32:53 GMT

We are working with a customer that can't download into Excel over 85,000 rows of data without it locking their machine. We are using Qlikview 10 SR4 and the user coming through the IE with the Qlikview IE Plugin version 10. Has anyone had this issue? Any work arounds that worked? Should we buy a new BI tool..maybe Tableau would export the data better? Mr. Farmer help!

Re: Trying to Export 85,000 rows into Excel from Qlikview

Wed, 22 Jan 2014 01:02:23 GMT

Hi,

I have faced this issue from QV11 desktop client max you can export to excel is 65000 rows .At that time i have exported all the data as csv .

Regards,

Abhishek

Re: Trying to Export 85,000 rows into Excel from Qlikview

Anonymous — Wed, 22 Jan 2014 01:23:24 GMT

Re: Export to Excel issue

There's a setting that you can change to increase the limit before the data is exporting in csv format:RowLimitForCsvInsteadOfXls

On the server you can change the limit in the QVS settings.ini file

[Settings 7]

RowLimitForCsvInsteadOfXls=65500

In Qlikview Desktop you can change this with an 'easter egg' setting. In the Help menu select About Qlikview. Then right click on the Qlikview icon in the lower left corner. Find the entry RowLimitForCsvInsteadOfXls. You can then increase the value from 65500 to a higher number. Note, this may cause a performance penalty on your server.

Re: Trying to Export 85,000 rows into Excel from Qlikview

Wed, 22 Jan 2014 01:32:17 GMT

Hi,

In my version (10 SR3) I can export an array in .xls up to 65,000 rows (normal limit for old Excel), if more it turns into a csv.

When I can I store in csv via script; it goes so fast...

Solution could be, storing in csv (or xlsx) via a macro. Something along these lines:

Sub ExportToCSV

Set ExportObject = ActiveDocument.GetSheetObject("(ObjectCode)")

ExportObject.Export "(FileAdress)\(FileName).csv", ";"

End Sub

Hope it helps.

Re: Trying to Export 85,000 rows into Excel from Qlikview

Wed, 22 Jan 2014 04:44:48 GMT

Save the excel file in .xlsx format. And try to reload the document.

It worked for me with morethan 1 Lakh records

Regards

Senthil Kumar P

Re: Trying to Export 85,000 rows into Excel from Qlikview

senpradip007 — Wed, 22 Jan 2014 05:16:57 GMT

Hi Scott.

Save your excel file in .xlsx format and try export the data. It allows you to store 1048576 rows of data.

Regards.

Re: Trying to Export 85,000 rows into Excel from Qlikview

Wed, 22 Jan 2014 05:23:21 GMT

Write macro for export the excel in .xlsx format. It will export morethan 1 lakh rows