Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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...
Were you able to achieve what you were trying to do @anushree1 ? I have a requirement to do something similar.