Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
"
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.
"
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.
Hi
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
Hi Scott.
Save your excel file in .xlsx format and try export the data. It allows you to store 1048576 rows of data.
Regards.
P
Write macro for export the excel in .xlsx format. It will export morethan 1 lakh rows