Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-01-21 07:32 PM

Trying to Export 85,000 rows into Excel from Qlikview

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!

3,891 Views
0 Likes
6 Replies
Not applicable
‎2014-01-21 08:02 PM
Author

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

1,481 Views
0 Likes
Anonymous
Not applicable
‎2014-01-21 08:23 PM
Author

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.

"

1,481 Views
Not applicable
‎2014-01-21 08:32 PM
Author

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.

1,481 Views
0 Likes
Not applicable
‎2014-01-21 11:44 PM
Author

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

1,481 Views
0 Likes
senpradip007
Specialist III
Specialist III
‎2014-01-22 12:16 AM

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

1,481 Views
0 Likes
Not applicable
‎2014-01-22 12:23 AM
Author

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

1,481 Views
0 Likes