Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

Limit the Number of Rows on Export to Excel

Hi,

I have a straight table showing around 100000 rows , but when exporting to excel I would want it to export only 10000 though the qlikview chart displays 100000 rows, I did try using RowLimitForCSVInsteadofExcel setting but  it does not seem to work as it exports all the rows even if i set it to 100 and CSV conversion is taking more time as well.

Could someone suggest on implementing this

13 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

The best way to do this (which does not require a macro), is to either

(1)  Use a calculation condition that prevents the export table from being displayed or exported until the user has made sufficient selection to reduce the table

(2) Create a sheet object that only displays 10.000 rows  using Dimension Limits or RowNo()

I prefer the former as the first 10.000 rows may not be properly representative and this requires the user to request more specific information which may be more relevant.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
anushree1
Specialist II
Specialist II
Author

Hi Jonathan,

The requirement is to show all the rows on qlikview and export only 10000 rows but using the suggested method I would restrict the number of rows showed on the qlikview as well which is not desirable

jonathandienst
Partner - Champion III
Partner - Champion III

You expect the user to get value from a table containing 100.000 or 1.000.000 rows?

You could of course create a duplicate object with reduced size for export...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
aiguo
Contributor
Contributor

Were you able to achieve what you were trying to do @anushree1 ? I have a requirement to do something similar.