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
load your sample in another table before store :
first 10000 load *,1 as tmp resident your table ;
drop field tmp;
store csv into file.csv (your csv options) ;
You can use a script to show only the necessary numbers that you want to be extracted to excel.
Kindly provide your sample app so that I can check it.
I do not want to restrict the number of rows to be loaded, i only want to restrict the number of rows exported onto excel, so the suggested approach would not work
writing the script would reduce the rows appearing on qlikview chart as well, i do not want that all i need is though the chart has 1000000 rows when i right click and export to excel it should export only 10000 rows
I think the Maximum for Excel export is around 1M cells.
If you want to adjust the behavior of the export button itself, maybe you can modify it using Macro.
I can put a link for you of someone who also shared his macro on creating an Export limitation.
You can just tweak it for yourself.