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

Limit the Number of Rows on Export to Excel

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

12 Replies
ogautier62
Valued Contributor II

Re: Limit the Number of Rows on Export to Excel

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
Contributor III

Re: Limit the Number of Rows on Export to Excel

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

else

first x load;

ksomosera10
Contributor II

Re: Limit the Number of Rows on Export to Excel

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

Re: Limit the Number of Rows on Export to Excel

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

Re: Limit the Number of Rows on Export to Excel

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

Re: Limit the Number of Rows on Export to Excel

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

ksomosera10
Contributor II

Re: Limit the Number of Rows on Export to Excel

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

Re: Limit the Number of Rows on Export to Excel

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

ksomosera10
Contributor II

Re: Limit the Number of Rows on Export to Excel

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!