Disable/Limit Export Table Functionality Based on Number of Rows

[Anonymous]

I'm looking to disable the export functionality on a Table object (Qlik Proprietary) if the row count of the table is above 100,000 for server performance reasons, or to only export the first 100,000 rows of the table.

So when a user makes a selection that results in more than 100,000 rows in the table, the desired result is either:

1. The table cannot be exported
2. The first 100,000 rows are exported only.

Thanks

[Aiham_Azmeh]

Hi callum.stevens‌,

If you are building a custom table visualization; you should be able to use the expordData property as a function: http://help.qlik.com/en-US/sense-developer/3.2/Subsystems/APIs/Content/ExtensionAPI/exportdata-prope...

I am not sure if this is possible for native objects.

I hope this helps,

[Digvijay_Singh]

Hi,

Did you find any solution for this problem. In our case, when data volume is very high, the table is not loading and its causing CPU and memory to 100% utilization within few seconds. I could find the way to restrict no of records to be viewed using calculation condition but the way we built export functionality, its again trying to export everything irrespective of calculation condition. Looking for better solution to this problem.

[Digvijay_Singh]

We are using app.visualization.create('table' to create the table.

[rsdhavle]

Did it restrict number of rows visible at a time from the table?