Limit the Number of Rows on Export to Excel

[anushree1]

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

[ogautier62]

Hi

load your sample in another table before store :

csv:

first 10000 load *,1 as tmp resident your table ;

drop field tmp;

store  csv into file.csv (your csv options) ;

regards

[manoj217]

use autogenerate function it will creates unique numbers then use load where condition < x

else

first x load;

[ksomosera10]

Hi Anushree,

Good day.

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.

Thanks!

[anushree1]

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

[anushree1]

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

[anushree1]

I want it to work from the front end so that the selections made also has an effect

[ksomosera10]

Hi,

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.

Thanks!

[anushree1]

Could you please share the macro in case you have it handy

[ksomosera10]

Hi,

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.

Thanks!