topic Re: Disable/Limit Export Table Functionality Based on Number of Rows in Integration, Extension & APIs

Disable/Limit Export Table Functionality Based on Number of Rows

Anonymous — Mon, 10 Apr 2017 10:19:55 GMT

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:

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

Thanks

Re: Disable/Limit Export Table Functionality Based on Number of Rows

Aiham_Azmeh — Mon, 10 Apr 2017 10:42:36 GMT

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-property.htm

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

I hope this helps,

Re: Disable/Limit Export Table Functionality Based on Number of Rows

Digvijay_Singh — Wed, 06 Dec 2017 05:38:15 GMT

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.

Re: Disable/Limit Export Table Functionality Based on Number of Rows

Digvijay_Singh — Wed, 06 Dec 2017 05:39:39 GMT

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

Re: Disable/Limit Export Table Functionality Based on Number of Rows

rsdhavle — Thu, 11 Oct 2018 10:36:07 GMT

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