topic Re: Export limit on Straight table in QlikView

Export limit on Straight table

govind1501 — Wed, 20 May 2020 12:47:44 GMT

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,

Re: Export limit on Straight table

raji6763 — Thu, 11 Jun 2020 11:13:22 GMT

hi,

there are two ways:

need to change the selections
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

Re: Export limit on Straight table

Brett_Bleess — Tue, 16 Jun 2020 15:12:58 GMT

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