Export limit on Straight table

[govind1501]

Hi Team,

I have 3000 rows data in my straight table but i want to allow users to export only 1000 rows from it. Only export limit needs to be restricted but not the data in table.

Can you please advise me on how to achieve it. 

Note: Please advise me without using macros.

Thanks,

[raji6763]

hi,

there are two ways:

1. need to change the selections 
2. use macro

you can try the below:

go to Presentation -> Max Number = 1000. That will show the first 1000 based on whatever sort order the user chooses.

(or)

 Go to Calculation Condition on General tab(if you have common key)

= Dimension_Primary_Key <= 1000

regards,

raji

[Brett_Bleess]

There is no function for what you are trying to do and how you are trying to do it.  The closest things would be the following two settings discussed in the following Article:

Export to Excel 

It is not precise, you could likely get close, but no means to dial it in to the exact number of rows you want.  Best I could recommend is to submit an enhancement request, or check to see if there is already one there in the following area:

https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Regards,
Brett