Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
MVP
MVP

Re: Limit the Number of Rows on Export to Excel

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
Valued Contributor II

Re: Limit the Number of Rows on Export to Excel

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

MVP
MVP

Re: Limit the Number of Rows on Export to Excel

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