Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Limit length of data export

Hi everyone,

I am trying to limit the length of a data export induced by the exportData() API call.

I have a Mashup where the underlying dataset can be downloaded via a button on the website.

To achieve this I create a table object via a .visualization.create() call and then I download the data behind this table via the exportData() function.

However I want to limit the length of the download. E.g. If the table actually has 10000 rows I only want to provide the first 500 for download.

As of now I create the whole download with all rows included and then throw away the rows that I don't want to show. This is a messy workaround I would like to avoid and also hurts the performance as the preparation of large datasets takes quite some time.

So I would like to know if there is a possibility to limit the dataset before downloading or if it is possible to modify the exportData function to only return a certain amount of rows.

Has anyone some experience with this?

Thanks and kind regards,

Marco

0 Replies