Discussion Board for collaboration related to QlikView App Development.
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.
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
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...